Master calendar and drill down master dimension

[morenoju]

Hi guys,

I have a master calendar with fields such as Year_A, Month_A, Day_A and Date_A.

The facts tables use start_date.

Normally I can do easy counts such as "Count({<start_date=P(Date_A)>}event_code)", but what about when it comes to a master dimension that I want to use to drill down in a bar chart?

I used to have a master dimension with Year, Month and Day. Now that I'm using the master calendar I changed it to Year_A, Month_A, Day_A. How do I get it linked to start_date so it counts events from the facts table?

I'm using "Count({<start_date=P(Date_A)>}event_code)"  but it does not seem to be right.

Thanks

[dplr-rn]

You master calendar is not linked to the start_date? Can i ask Why?

if there are multiple date fields try with a canonical date approach maybe more flexible

[morenoju]

Hi, I'm having a look at this issue again. I now have a master calendar linked to start_date as @dplr-rn had mentioned.

I'm configuring the drill-down as Year, Month, Day from my master calendar.

In the bar chart, I still want to show days where data = 0 for them, so I'm counting like this in the measure:

Count(code) + 0 * Count({1}code)

Now my problem is that all months are showing up to 31 days. How can I make it so August shows 31 days, September 30, etc.?

Thanks