Forum Discussion

pmahendra's avatar
pmahendra
New Contributor
2 years ago

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

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?    
Cubes
Metadata
Methodology
NickHymes's avatar
NickHymes
New Contributor III
2 years ago

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.