Creating a report from two different cubes.

Post Reply
rduggs
Posts: 10
Joined: Fri Jan 22, 2010 3:19 pm
OLAP Product: tm1
Version: 9.4
Excel Version: 2007

Creating a report from two different cubes.

Post 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
kpk
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.

Post 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
Best Regards,
Peter
rduggs
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.

Post by rduggs »

Thanks Peter.
rduggs
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.

Post 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
rduggs
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.

Post by rduggs »

If we set the user privileges to read only for the sliced cube...then it will work...

Thanks,

Rdug
Post Reply