error after clicking on Hide Empty Rows/Columns

0

I have a simple cube and a simple olap view. it works fine but when I click on "Hide Empty Rows/Columns", it makes an error

if anyone knows what's the problem please help me

my schema:

<Dimension name="Date" type="TimeDimension">
<Hierarchy hasAll="true" primaryKey="date_pk" allMemberName="all periods" defaultMember="all periods">
<Table name="date"/>
<Level name="Year" column="year" type="Numeric" uniqueMembers="false"
levelType="TimeYears"/>
<Level name="Month" column="month" uniqueMembers="false" type="Numeric"
levelType="TimeMonths"/>
<Level name="Day" column="day" uniqueMembers="false"
levelType="TimeDays"/>
 
</Hierarchy>
</Dimension>
 
 
<Cube name="AccountCreateCube">
<Table name="account"/>
 
<Dimension name="Bank Branch" primaryKey="account_branch_code">
 
<Hierarchy hasAll="True" allMemberName="all branches" defaultMember="all branches">
<Level name="Branch Id" column="account_branch_code" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<DimensionUsage name="Insert Date" source="Date" foreignKey="insert_date_id"/>
<Measure name="count" column="account_number" aggregator="count"/>
</Cube>
 
y_mash's picture
40
Joined: Sep 7 2014 - 3:12am
Last seen: 4 years 6 months ago

1 Answer:

0

I have found the solution. the problem was that I had a level in my schema of type bigint in postgresql. I don't know why the values became float. so I added type="Numeric" in that level and it works fine

y_mash's picture
40
Joined: Sep 7 2014 - 3:12am
Last seen: 4 years 6 months ago
Feedback