Page 1 of 1
Creating a report from two different cubes.
Posted: Sat Mar 13, 2010 6:06 pm
by rduggs
Hey Everyone:
Does anyone have any documentation on how to create a dynamic report comprising of dimensional data from two different cubes. Your help will be highly appreciated.
Thanks,
Rdug
Re: Creating a report from two different cubes.
Posted: Sat Mar 13, 2010 11:15 pm
by kpk
What do you mean on dynamic?
1. Excel report based on 2 slices?
http://forums.olapforums.com/viewtopic. ... 795#p10795
2. active form: you can see some info on the "dependent section" in the user guide
Regards,
Peter
Re: Creating a report from two different cubes.
Posted: Sun Mar 21, 2010 11:33 pm
by rduggs
Thanks Peter.
Re: Creating a report from two different cubes.
Posted: Sun Mar 28, 2010 10:34 pm
by rduggs
I`ve a question regarding:
i) the web based reports created from two slices and
ii) the active form reports.
My client has a web template which is used for adding new product sales to the TM1 Profit and Loss cube. They want a sliced report from the P&L cube to be added to the web template to see impact of the sales on the overall profit and loss statement cube in real time.
Since the real time based Sliced reports as well as active form reports will have DBRW formulas in the cells, if by accidentally the front end users make any changes to the sliced data then integrity will be lost. What are my options?? Please help.
Thanks,
Rdug
Re: Creating a report from two different cubes.
Posted: Mon Mar 29, 2010 2:30 am
by rduggs
If we set the user privileges to read only for the sliced cube...then it will work...
Thanks,
Rdug