what is variable? give me one example? i want to display
12 months in a report..? how many varbles are used?
Answer Posted / dinesh5
Variables are place holders of values that are filled dynamically during query execution.
For your Example .
1) If you need 12 months of a year just use 0CALYEAR variable
EX : ZRP_YR_VAR
Get the cal year from user with following properties.
1) Manual entry/ default value
2) Variable is ready for input
3) Variable is Manditory
2) If you need any 12 months (maybe APRIL to March) variable use 0CALMONTH
create a new selection and add the keyfigure and ZRP_YR_VAR variable.
EX : ZRP_MONTH_ST_VAR
Get the Start calmonth from user with following properties.
1) Manual entry/ default value
2) Variable is ready for input
3) Variable is Manditory
create a new selection variable and restrict it to variable ranges
select start month as starting and
select Start month as end and offset it to 12 by right clicking and giving offset value.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Describe a opening balance?
What is modelling?
Where do we use infoset in bi system?
what are the data types for the characteristics info object?
Where do you find which table is currently being populated (BIW1 or BIW2)?
What is the number of decimal places in scaling factor?
What is sap bw/bi? What is the purpose of sap bw/bi?
What are the destination target options?
How to transport bw object?
Can you name a few important tasks which are essential in the data warehousing and management of the same?
what do you mean by transfer routines
What are the inputs for an infoset?
How do you transform OH data?
What is the attributes only flag?
You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?