Skip to Content
author's profile photo
Former Member

Text variable creation Error.

Hello gurus ,

I am working in BI 7

I have to design a Report in which i want follwoing key figures in column

Net volume (User entry range of month) Billing Product (same range of month)

Now the trickiest part is that whatever user enters on Selection Screen i.e the range of month of year they wanted to see the output,

they also want to see the same range entered in Report output.

For e.g.

user enters Jan-March 2007

Then in query output it shuld show

Net volume (Jan-March 2007) Billing Product (Jan-March 2007)

Like wise.

So if it aggregates the data for January to March , there is no worries.

What i did?

I restricted Net volume in Selection screen with Fiscal year/period.

I restricted Fiscal year/period with Standard Interval range variable.(Because in its technical name the prefix was "0")

Then i tried creating Text variable, and tried to include it in Description,

BUT OVER THERE WHILE INCLUDING IT , I WAS UNABLE TO SEE THE INTERVAL RANGE VARIABLE.

So i tried creating my own variable, and tried to use it.

IF i use my own created variable everywhere i dont get output.

But if i use Standard SAP provided variable everywhere, I am unable to include it while creating Text variable.

Where did i go wrong ?

For text variable i followed this procedure

Message: Create Text Var - >Type of var - Text ->Processing type - Replca Path ->Time char on which u hav created the interval var ->Replcaement Path - > Replacement Tab : Replacement Variable -Variable - > Variable - Giv the Interval Variable

- > Replace with key or text.

Please advise

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 29, 2007 at 10:38 AM

    Noviced,

    Best to create your own but you will need two. One to show you the From value and one to show you the To Value.

    When you are selecting the display type, you will see an option on that Dialogue box to show the From or To.

    Regards

    Gill

    Add comment
    10|10000 characters needed characters exceeded