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
Creating a report from two different cubes.
-
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Creating a report from two different cubes.
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
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
Best Regards,
Peter
Peter
-
- Posts: 10
- Joined: Fri Jan 22, 2010 3:19 pm
- OLAP Product: tm1
- Version: 9.4
- Excel Version: 2007
Re: Creating a report from two different cubes.
Thanks Peter.
-
- Posts: 10
- Joined: Fri Jan 22, 2010 3:19 pm
- OLAP Product: tm1
- Version: 9.4
- Excel Version: 2007
Re: Creating a report from two different cubes.
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
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
-
- Posts: 10
- Joined: Fri Jan 22, 2010 3:19 pm
- OLAP Product: tm1
- Version: 9.4
- Excel Version: 2007
Re: Creating a report from two different cubes.
If we set the user privileges to read only for the sliced cube...then it will work...
Thanks,
Rdug
Thanks,
Rdug