Please post questions like this in the BI forum, not here in the ramp up for 2004s
2ways- variable on fiscal period going from either 001 to user entered single variable or 000 to user entered single variable
or hierachy on fiscal period built on 001 - 002, 001-003, 001-004, etc.
Sarah
You need to set a range in your variable. For example, if you are using Fiscal Year/Period as an input parameter, and the end user enters 008/2006, you can have BW automatically output results from Jan 2006 to 008/2006. This is accomplished in the Analyzer by choosing a setting in the variable. Simply choose RANGE instead of SINGLE VALUE. Then you must tell BW the range. You do this by typing a "1" in the text box, followed by a semin-colon ";", then you switch to the variable tab, select the variable, and then click the right arrow. When you look in the right pane, you will see the variable with "1;variable" underneath it. This is a little hard to describe, but it should set you on the correct path. Happy to provide more guidance.
Add a comment