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>
