Sorry all that – i couldn’t post any technical update for so long & my apologies for that…
I believe, today’s tech update would help some users when they come across such requirements..
Requirement:
Can we pass the prompt inputs as the metric name (i.e.) changing the metric names dynamically based on the prompt inputs
Solution:
Yes, it is possible. You can achieve this by going for Dynamic Value text option on web
Things Required:
– Report with attributes/metrics/prompts (For Dates as example here)
– Take the path of the Prompt that is used (Eg: /Public Objects/Prompts/Value(Date) )
– MicroStrategy Web to apply them
– User should have the option/privilege to edit/rename the objects
– Save options is also required – since, it won’t work until you save the report in web
Steps to Perform:
- Create a report with Year, Quarter, Revenue, and a prompt on Year
- Rename the Revenue metric
- Using the provided syntax ( ?[prompt name] ), include the Year prompt in the metric name and click OK.
- Now, the value’s dint appear with the selected year because, the user need to save the report and check
- Save the report and then run it to see if it works or not.
Note:
– If on any cause, your editing the report in MicroStrategy Desktop and saving it means –> The Dynamic Value text will go and won’t work for the next time when you run in web.
– So, i would advise you to modify the reports in web and save them accordingly.
Have a Good Day!