Forum Discussion
Multiple Calendars for Multiple Companies
This is pretty much what we are doing now. We have groups and each group has it's own fiscal calendar. I simply join to the fiscal calendars in my tabular model through my regular calendar on the date key field and then access the fiscal parts of the group's calendar by slicing on the Fiscal Calendar name. This gives me one calendar to work with given a slice of the group table. It's working okay and I think this is the direction we are going to take.
This is pretty much what we are doing now. We have groups and each group has it's own fiscal calendar. I simply join to the fiscal calendars in my tabular model through my regular calendar on the date key field and then access the fiscal parts of the group's calendar by slicing on the Fiscal Calendar name. This gives me one calendar to work with given a slice of the group table. It's working okay and I think this is the direction we are going to take.
Is there an example of how you achieved the appropriate result?
Hi
Do you perhaps have an example of the solution?
Anonymous - I think have a similar problem - perhaps you can help me if I provide you with an actual data?
I am struggling to model a scenario where the client has eg 5 companies and some of them have different monthly reporting periods.eg some reports on calendar basis 1st to last day of month and some on say 26th - 25th.Do you have a suggestion on how to handle this so that I can analyse at a client level (aggregating all companies)?