6 Replies Latest reply: Jan 21, 2013 5:50 AM by User294199 RSS

    Passing prompt presentation variable in Navigate URL

    User294199
      Hi,
      I have one field prompt called "View" associated to presentation variable "TimeView"
      Then i have a request where facts f(x) fields formulas are related to presentation variable in this way: FactTable. Sales @{TimeView}{Monthly}. My request has also two where conditions on Time.Year and Entity.Description fields.

      I need to access directly to request by browser URL, Passing Filters to the request through the Go URL.

      Following documentation: [!http://gerardnico.com/wiki/dat/obiee/url_filter!] i've created following url statement:

      sit01ap01epmt.root.sys/analytics/saw.dll?Go&Path=/shared/Amplifon Technomind/01a Sales Trend
      &Action=Navigate&P0=2&P1=eq&P2=Entity.Description&P3="Country Italy"&P4=eq&P5=Time.Year&P6="2012"

      All works fine, in fact my request is correctly filtered by Year 2012 and Description Italy.

      Now i need to pass also my presentation variable my_var which value must be substitued dinamically within my facts f(x) fields formulas.

      How can I modify my URL to achieve this?

      Best Regards

      Giancarlo
        • 1. Re: Passing prompt presentation variable in Navigate URL
          Jack Carver
          You can do it only with POST query, not GET.

          Look at simple example - [url http://obi2ru.blogspot.ru/2009/10/biee-calling-dashboard-and-passing.html]http://obi2ru.blogspot.ru/2009/10/biee-calling-dashboard-and-passing.html
          (example written in russian, but you can translate it - use googleTranslate at right-upper corner)

          Edited by: Jack Carver on 14.01.2013 5:25
          • 2. Re: Passing prompt presentation variable in Navigate URL
            GRK
            Hi,

            I think you can pass any kind of prompt variable using Go URL method.

            Go through this link it might help you: http://sureshotstrategies.wordpress.com/2008/12/13/integrating-oracle-obiee-content-using-go-url-syntax-2/
            • 3. Re: Passing prompt presentation variable in Navigate URL
              Srini VEERAVALLI
              Try something like below

              sit01ap01epmt.root.sys/analytics/saw.dll?Go&Path=/shared/Amplifon Technomind/01a Sales Trend
              &Action=Navigate&P0=3&P1=eq&P2=Entity.Description&P3="Country Italy"&P4=eq&P5=Time.Year&P6="2012"&P7=eq&P8=FactTable. Sales&P6='@{TimeView}'

              If helps pls mark
              • 4. Re: Passing prompt presentation variable in Navigate URL
                User294199
                Hi,
                thanks for your solution but i think it isn't applicable in my case. Problems are two:

                1) My fact table column name isn't static but it changes dinamically depending on my_var value. It can assume three values: Monthly, Qtd, Ytd depending on choice user makes on prompt. So in my f(x) column formula i have something like this:

                Fact.Sales @{TimeView}. So it can assume following three values: Fact.Sales Monthly - Fact.Sales Qtd - Fact.Sales Ytd. In my rpd there's a measure column for each case. FactTable. Sales only doens't match

                2) I load only the report and not whole dashboard page (prompts included). So if I write &P8=FactTable. Sales&P6='@{TimeView}' i'd assign to P8 parameter a null value because no one set the variable.

                Best Regards

                Giancarlo
                • 5. Re: Passing prompt presentation variable in Navigate URL
                  Jack Carver
                  Look close at my example above. It describes initialisation of presentation variables by POST http request.
                  • 6. Re: Passing prompt presentation variable in Navigate URL
                    User294199
                    Hi,
                    even if for my knowledge document is a little bit complicated, i have tried to insert code in a Text element in a Dashboard Page marking it as HTML code. But seems OBIEE doesn't recognize code infact in preview the code is shown as is.
                    There's something wrong? Where can i insert code?
                    Can you explain the procedure step by step?

                    Thanks

                    UPDATE: I've tried to insert code in a jsp file under Tomcat. Form button is shown correctly but debugging the code i receive following error:

                    Syntax error: Missing ; before following statement:

                    tForm.P0.value = "< sawx: expr xmlns: sawx = \ "com.siebel.analytics.web/expression/v1 \" xsi: type = \ "sawx: Logical \" OP = \ "and \" xsi: type = \ "sawx: list \" op = \ "in \" xsi: type = \ "sawx: untypedLiteral \"> XXX value </ sawx: expr > </ sawx: expr > < sawx: expr xmlns: sawx = \ "com.siebel.analytics.web/expression/v1 \" xsi : type = \ "sawx: list \" op = \ "in \" xsi: type = \ "sawx: untypedLiteral \"> YYY value </ sawx: expr > </ sawx: expr > </ sawx: expr > ";

                    Edited by: 832596 on 21-gen-2013 3.40

                    Edited by: 832596 on 21-gen-2013 3.49