7 Replies Latest reply: Feb 22, 2013 2:27 PM by Avinash Pentyala RSS

    dynamic graph title

    770542
      Hi,

      i am using Oracle Business Intelligence 11.1.1.5.0.

      and i want to make a graph title dynamic, it must changes accordng to the month names.

      is it possible?

      or is there any way to do this with an another way, i mean using any other views, text, static or sth else

      thank you
        • 1. Re: dynamic graph title
          Avinash Pentyala
          Add Title view to Analytics and Create Dynamic variable for Month Name.
          After edit title view add below syntax
          @{biServer.variables['CURRENT_MONTH']}

          Here CURRENT_MONTH Is Dynamic variable.then hide chat titles.

          It helps Plz Mark...:)
          • 2. Re: dynamic graph title
            770542
            958741 wrote:
            Add Title view to Analytics and Create Dynamic variable for Month Name.
            After edit title view add below syntax
            @{biServer.variables['CURRENT_MONTH']}

            Here CURRENT_MONTH Is Dynamic variable.then hide chat titles.

            It helps Plz Mark...:)
            thank you for your help,
            there is a dynamic variable V_MONTH
            and i am using @{biServer.variables['V_MONTH']}

            but it doesn't working, it appears same as below, (i am writing it to the caption)

            any idea please?
            • 3. Re: dynamic graph title
              Avinash Pentyala
              Let us try like this

              1.Add month name column criteria.
              2.In Edit Formula use V_Month variable.
              3.Add Narrative view then use column number like '@1'
              4.Add month name column Excluded mode in chat view.

              If helps mark.... :)

              Thanks,
              Avinash
              • 4. Re: dynamic graph title
                770542
                1.Add month name column criteria.
                2.In Edit Formula use V_Month variable.
                3.Add Narrative view then use column number like '@1'
                4.Add month name column Excluded mode in chat view.
                1. OK
                2. OK
                3. OK
                4. couldnt understant what you mean,

                where is char view? and i am using bi 11

                thank you for your help.
                • 5. Re: dynamic graph title
                  Avinash Pentyala
                  4. couldnt understant what you mean,

                  where is char view?


                  means place the month Name column in Excluded section in Graph View.

                  what is char view?---I can't understand.

                  if it is help plz mark?

                  thanks,
                  Avinash
                  • 6. Re: dynamic graph title
                    770542
                    >
                    means place the month Name column in Excluded section in Graph View.
                    sorry but i couldnt understand,

                    if i remove from graph view, how can i use as a title?

                    Edited by: odilibrary.com on Feb 22, 2013 3:01 PM
                    • 7. Re: dynamic graph title
                      Avinash Pentyala
                      sry that my mistake.Finlay that is working for you ..