want to create customised month dimension?

[rupaliqlik]

Hi Expert,

In my application i want to create customised  month dimension which contains all the month names,quarters, and YTD calculation.Please tell me how to make this.Is it possible ?

[vinieme12]

I believe you need a master calendar

Creating A Master Calendar

[johnw]

Yes, it's possible. Build a table that looks something like this, and use Month Group as your dimension.

Month Group, Month
2015, Jan-15
2015, Feb-15
...
2015, Dec-15
2016 YTD, Jan-16
...
2016 YTD, Jul-16
...
Q1 2015, Jan-15
Q1 2015, Feb-15
Q1 2015, Mar-15
...
Jan-15, Jan-15
Feb-15, Feb-15
Mar-15, Mar-15
...

Let me know if you need help building this table. You wouldn't do it as an inline load. I'm just showing what you'd want the data to look like.

[rupaliqlik]

Hi John,

I want dimension like this

Jan-15

Feb-15

Mar-15

Apr-15

May-15

Jun-15

Jul-15

Aug-15

Sep-15

Oct-15

Nov-15

Dec-15

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

Q1

Q2

Q3

Q4

YTD Actual

.So user can see monthwise, quarterwise and ytd wise business in one shot.

[vinieme12]

Please refer the link

Period Presets: Compare Periods on the fly

[johnw]

"I want dimension like this...So user can see monthwise, quarterwise and ytd wise business in one shot."

Yes, I understood that, and what I posted is one way to create that dimension. It also pretty much matches what Vineeth posted. My "Month Group" is his "Period", and he's linking to dates instead of to months, but it's the same basic idea, and a way of creating the linkage table that I'm going to need to remember. I don't think I ever used crosstable to do it, but that seems like such a simple, elegant solution. Thanks, Vineeth!

[vinieme12]

Hi Rupali,

Can you close this post now?

[MarcoWedel]

Hi,

maybe one solution could be a pivot table with month, quarter and year dimensions and partial sums:

hope this helps

regards

Marco