15 pts.
 Microstrategy(Reporting tool)
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.

Software/Hardware used:
ASKED: September 24, 2008  6:00 AM
UPDATED: July 22, 2010  5:27 PM

Answer Wiki:
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  Smpsj   30 pts.
All Answer Wiki Contributors:  Smpsj   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _