how to make an dimension upto and including month's

[MiRRo]

Hi guyz, I have an dimension time and dimension month includes januarie upto december, now i want to make an dimension month upto and including month. Example month march; If you select in dimension month upto and including march it have to show januari,februari and march. I took a look in relative time tab but did not came further. Thx for your help.

Love for all!!

MiRRo

 

[Kaiaualad]

I think you need to fully use the relative time in the model,It sounds like a Year to Date relative time category you are looking for.
The help PDF shows you how to set it up - if your time Dimension is a 'time type' one,All the relative categories would be automatically set up for you.
Ensure the Date or year category in the Datasources list .iqd Properties is set to Date Data Class, and the Dimension Properties are ticked for 'Sets current time period'

 

[MiRRo]

Hi people, I resolved my problem by calculating the catagories in dimension month in the diagram. Example upto and including month march=januari+februari+march. Thx anyway!!

MiRRo

 

[Kaiaualad]

Thats great - but havent you just hard coded it into the model, so that next month you will have to go in and add the next month into the calculation?

 

[MiRRo]

Hi Kaiaualad, dimension month isn't an regular time or relative time dimension I made it as an calculated column which has the expression month ( "Invdate" ), so month already includes januari upto and including december. Then i calculated the catagories (which are months)to get upto and including month. Now i dont need to add next month because nextmonth and other next months already exist. Thx for your comment and if you still have some tell me I am open for comments.

Greetings,

Mirro