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


Please Help Members By Posting Answers For Below Questions

Describe a opening balance?

1737


What is modelling?

747


Where do we use infoset in bi system?

704


what are the data types for the characteristics info object?

739


Where do you find which table is currently being populated (BIW1 or BIW2)?

1896


What is the number of decimal places in scaling factor?

1774


What is sap bw/bi? What is the purpose of sap bw/bi?

649


What are the destination target options?

1785


How to transport bw object?

796


Can you name a few important tasks which are essential in the data warehousing and management of the same?

691


what do you mean by transfer routines

709


What are the inputs for an infoset?

843


How do you transform OH data?

1674


What is the attributes only flag?

735


You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?

674