- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
want to create customised month dimension?
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I believe you need a master calendar
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please refer the link
Period Presets: Compare Periods on the fly
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Rupali,
Can you close this post now?
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
maybe one solution could be a pivot table with month, quarter and year dimensions and partial sums:
hope this helps
regards
Marco