Hyperion Financial Reporting - FR 931 data from two different cubes
Hi All,
Hope someone might have good thoughts/suggestions. Here is what i have for a report
I need to pull the accounts from two different cubes say like Account1,Account2 from cube ABC and Account11, Account22 from cube XYZ these two cubes has got same hierarchy and the member names for time period and market dimensions - There is a customer dimension in both the cubes but some of the customers do not exist in both cubes. For Ex: Cus1 is existing in cube ABC but do not exist in XYZ. I need a layout/report like this
All customers and the accounts on rows, time periods on columns, I would like to use the market as POV to both the grids so that the 1 selection is applied to both the grids
appreciate your time