Hi,
I have one question regarding TM1 perspectives reporting.
Please help me with your valuable input.
Can we create prompts for the reports developed in excel/perspectives based on the report column.I don't want prompts for the cube (Only for reports).
Please share the related documents ,if you have any.
Thanks,
Sudheen
Can we have prompts for TM1 Perspectives reports?
-
- Posts: 11
- Joined: Mon Dec 28, 2009 10:38 am
- OLAP Product: Cognos
- Version: 9.5
- Excel Version: 2007
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Can we have prompts for TM1 Perspectives reports?
Hi Sudheen,
You might want to rephrase your question. What do you mean by "prompts".
Cheers
You might want to rephrase your question. What do you mean by "prompts".
Cheers
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Can we have prompts for TM1 Perspectives reports?
Depending on your level of Excel skill and how complex you want to make formulas you can make excel based TM1 reports quite dynamic. (Eg. changing the row or column set, changing a filter selection, sorting, even swapping a filter dimension and row/column dimension).
However more complexity in formulas will make reports likewise more complex to build and maintain and will also have a performance impact (especially if you want to render reports on the web.)
However more complexity in formulas will make reports likewise more complex to build and maintain and will also have a performance impact (especially if you want to render reports on the web.)