Good morning! I'm connecting to an Essbase cube that has a Years dimension (FY16,FY17,etc) and a Period dimension (YearTotal, Quarters, Months). Is there any way to make a time dimension out of these two separate dimensions? I want to be able to use time series functions in some analyses. Thanks!
edit: We're using OBIEE 11g 11.1.1.7.151020
No. If your cube is designed that way then there's no way of logically wrangling it into shape.
Common issue with many Essbase cubes designed like that when you're trying to utilize them in an analytical way.