error after clicking on Hide Empty Rows/Columns

[y_mash]

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]

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