Hi,
I have to display the current year which are selected in the prompt
and also the last year for the current year selaction in the report using Microstrategy.
Maha,
You need to display current year and previous year in report.
In such case,You have an attribute named year,that should be placed in Report grid.
And year prompt created with Year attribute which has number of years.
Create a new report with placing year prompt into Report filter,and keep year attribute into report grid.
For getting previous year for year selected from Year prompt dynamically,you should create new transformation for year attribute.
By default you are having Previous year or else give calculation like,(Year-1).
Try this................
Thanks,
smpsj
Last Wiki Answer Submitted: July 22, 2010 5:27 pm by Smpsj30 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.