A single cube that can be used to analyze data from multiple calendar years

Question

Hi everyone-I am trying to create a reporting solution that can display data from two close calendar periods in a single cube. Is it possible to include two time profiles in a single cube?
&nbsp;
&nbsp;

NickHymes · Answer

Are you doing this for reporting purposes? You can actually build cube view reports to reference multiple cubes when reporting. Simply call out the dimension token cb# under one of your row or column expressions and state the name of the cube.&nbsp;

JackLacava · Answer

I'm not sure what you mean by "close calendar periods", but you can only have one Time Profile per Cube. A Time Profile includes a number of years, of course.
This said, different Scenarios can work with different levels of such profile, i.e. one can have weekly data and the other can have monthly data, so typically you can still accommodate all data in one cube if you wish. The setting can even change by time, so you can have scenarios that start as weekly and become monthly later on, or viceversa.
If that's not enough, you can still display data from other cubes through a Dynamic Calc formula on a member (typically a UD8), which runs at reporting time and can retrieve data from anywhere.

Forum Discussion

A single cube that can be used to analyze data from multiple calendar years

Related Content

Calculating Working Day vs Calendar Day

Literal parameters and multiple users

Combobox Multiple select option.

Import data using multiple workflow profles

Importing XFD multiple amount columns