20 Replies Latest reply: Mar 4, 2012 10:03 AM by Jordan Lazarus RSS

Text variable

Tanka Ravi Chandra
Currently Being Moderated

Hi all ,

 

 

I have a query with 3 selection keyfigure and that has to display the rolling quarter month results. I created the offset from the variable and what i need  now is that i need display the corresponding quarter month as the column header  i know that i can achieve that with the help of customer exit , but plz can anybody tell me the step i have seen the aritcle but unable to get that plz don't  send the link

 

Regards,

RaviChandra

  • Re: Text variable
    Jordan Lazarus
    Currently Being Moderated

    Hi,

     

    You can create 3 text variables for each of the key figures with rolling quarters.

     

    Use Processing Type as "Replacement Path" while creating the text variables and replace using the particular info-object/variable value.

     

    Hope this helps

     

    Regards,

    Joe

    • Re: Text variable
      Tanka Ravi Chandra
      Currently Being Moderated

      Hi

       

      I know those step but what i need is that suppose i have created 3 selection S1,S2,S3 and 3 TEXT VARIABLES TV1,TV2,TV3 and i have created the variable that have to take the user input month , i gave this variable to the text variable tv1 WITH REPLACEMENT PATH and what variable i have to pass for these tv2 and tv3 SO THAT THE ROLLING QUARTER WILL BE DISPLAYED AS A TEXT HEADER.

       

      Regards,

      RaviChandra

      • Re: Text variable
        Naveen Rao Kattela
        Currently Being Moderated

        Hi,

         

        If I understood your question correctly,

         

        TV1, TV2 and TV3 should have their own text variables type replacement path to get text from the time characteristic (ex: Fiscal Year/Period or Calendar month etc.,) you are restricting the KeyFigures in your query by Customer exit variables S1, S2 and S3 respectively.

         

        Hope this helps

         

        Thanks,

        Naveen Rao Kattela

      • Re: Text variable
        SVU 123
        Currently Being Moderated

        Hi Ravi,

         

        As per my understanding of your question,you want to have offsetting on text variables, cannot have offsetting on Text variables.

        The only workaround is through CMOD code.

         

        Rgds

         

        SVU123

      • Re: Text variable
        Jordan Lazarus
        Currently Being Moderated

        Ya, In this case instead of replacement path, you could do it using customer exit...

      • Re: Text variable
        Durgesh Gandewar
        Currently Being Moderated

        Hi Ravi,

         

        In your case you need only one text variable. Create a text variable with replacement path type and during variable creation select the required characteristic from which you want to derive the text say for e.g. 0CALQUARTER.

         

        After that you need to select with replace by text option. Once you finish creating text variable use the same variable in the column heading of all the three columns.

         

        The text value of the variable will be derived based on the characteristic value which got used in replacement path and based on the value of that characteristic in RKF the text will be derived.

         

        If you are using same characteristic (0CALQUARTER) in all the RKF then you can simply re-use the variable.

         

        Regards,

        Durgesh.

        • Re: Text variable
          Tanka Ravi Chandra
          Currently Being Moderated

          Hi durgesh,

           

          Thanx for the reply i did those step but i am getting the same text values for all the 3 selection keyfigure but what i want is "like creating the offset on the text variable "

           

          Hope u got it,

          Thanx & Regadrs,

          RaviChandar

          • Re: Text variable
            Durgesh Gandewar
            Currently Being Moderated

            Hi,

             

            You can not offset the text variable the text variable value is always derived based on the value of actual characteristic, so you need to offset the value of actual characteristic and then accordingly the value of the text variable will also change.

             

            Regards,

            Durgesh.

            • Re: Text variable
              Tanka Ravi Chandra
              Currently Being Moderated

              Hi durgesh,

               

              So now how can i achieve those offset setting in the text variable . Let say suppose i have 3 selection with offset  OS,OS-1, OS-2  and now i have to make the setting in the cmod and have to write the manual like that characteristic -1 . Is it the only way to achieve that thing.

               

              Regards,

              RaviChandar

              • Re: Text variable
                Durgesh Gandewar
                Currently Being Moderated

                Hi Ravi,

                 

                Let me give you a simple scenario that we have implemented in our project, we have a report where we need to display the revenue of three months in three different columns based on the user input of fiscal period.

                 

                Now we need to show the dynamic text of all the three column based on the user input month. I have created a Text variable TXT1 with replacment path setting over 0FISCPER.

                 

                After that I have created three RKF's RKF1, RKF2, RKF3 and I have put TXT1 variable in the heading of all the three variables.

                 

                The definition of my RKF1 consists of 0AMOUNT as key figure and 0FISCPER characteristic restricted by user input variable.

                the definition of RKF2 consists of 0AMOUNT and 0FISCPER with input variable and offset as -1.

                 

                In the report based on the RKF1 key figure 0FISCPER value the text displayed will be current month text e.g. January and at the same time the value returned by 0FISCPER in RKF2 will be offset by -1 and the text displayed will be December.

                 

                So practically you don't need to worry about the text value changes as long as you are using the same time characteristic you can use the same text variable.

                 

                Regards,

                Durgesh.

Actions