TM1 Forum

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

Hi Sudheen,
You might want to rephrase your question. What do you mean by "prompts".

Cheers

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.)