<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi,</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">I have a common date dimension as follows</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"> <Dimension name="Date"><br> <Hierarchy primaryKey="JALALI_ID" hasAll="false"><br> <Table schema="BIDWH" name="BAS_DM_DATE"
/><br> <Level name="Year" column="J_YEAR" uniqueMembers="true" type="Integer"/><br> <Level name="Month" column="J_MONTH" type="Integer"/><br> <Level name="Day" column="J_DAY" type="Integer"/><br> </Hierarchy><br> </Dimension></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">and I used it in all my cubes such as Deposit:</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new
york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"> <Cube name="Deposit" cache="false" enabled="true" defaultMeasure="DpCount"><br> <Table schema="BIDWH" name="COR_CB_DEPOSIT" /><br> <DimensionUsage name="OpenDate" source="Date" foreignKey="FD_OPENDATE"/><br></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"> <Measure
name="DpCount" column="MS_DEPOSIT_ID" <span><span><span><span>aggregator="distinct-count"</span></span></span></span>/></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"> <Measure name="MinMainAcc" column="MR_MIN_MAINACCOUNT" aggregator="sum" /><br></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"> </Cube></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent;
font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">when I execute MDX: </div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"><br></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);">select<br>[OpenDate].[Month].members on axis(0),<br>[Measures].[DpCount] on axis(1)<br>from Deposit</span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: Courier
New,courier,monaco,monospace,sans-serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"><span style="font-family: times new roman,new york,times,serif;"><span><span style="background-color: rgb(255, 255, 255);"><br></span></span></span></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: times new roman,new york,times,serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"><span style="font-family: times new roman,new york,times,serif;"><span><span style="background-color: rgb(255, 255, 255);">or</span></span></span><br></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal;"><span style="font-family: Courier
New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"><br></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);">select<br>[OpenDate].[Month].members on axis(0),<br>[Measures].[</span></span><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);">MinMainAcc</span></span>] on axis(1)<br>from Deposit</span></span></div><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"></span></span><div
style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Mondrian executes 93 SQL queries for each month like the following:</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);"><br></span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="background-color: rgb(255, 223, 191);">select "BAS_DM_DATE"."J_DAY" as "c0" from "BIDWH"."BAS_DM_DATE"
"BAS_DM_DATE" where ("BAS_DM_DATE"."J_MONTH" = 1 and "BAS_DM_DATE"."J_YEAR" = 1384) group by "BAS_DM_DATE"."J_DAY" order by "BAS_DM_DATE"."J_DAY" ASC NULLS LAST</span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">I don't understand the reason of such queries. I have the same problem with other cubes, and it takes so long for some cubes.<br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">I checked the MDX in versions 3.3.0.14703, 3.4.1, and 3.5.0 and the results are the same.</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new
york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Is my configuration wrong? Is there any solution to solve the problem?</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style:
normal;"><br></div></div></body></html>