7 Replies Latest reply: Feb 22, 2013 8:27 AM by Avinash P 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 P
          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 P
              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 P
                  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 P
                      sry that my mistake.Finlay that is working for you ..