Using variables as filters in analyses launched by Guided Navigation links

10-11  Source: Network gathering  Views:0 

Advertisement
I'm trying to build a navigation link that will launch an analysis and have the filters in that analysis respect the values of either Presentation Variables or Session Variables. I'm having success with an ordinary column. I'm not having success with a number that I need to type into a prompt.
Here's what I've done so far:
1. Created a dashboard prompt based on the Month column. When a Month is selected, that selection populates the Request (Session) variable called Selected_Mo
2. Created an analysis with:
- a filter on the Month column: = Selected_Mo
- the Month column
- a column showing the value of Selected_Mo
3. Placed both of those onto a dashboard page. When I select a value of Month, the month in the analyis changes, and the column showing the value of Selected_Mo changes. So far, all is good.
4. Placed an Action Link on the dashboard. That action link launches the same analysis that I can see on the dashboard.
5. Clicked the action link. The value of Month that I selected on the dashboard is shown in the analysis.
Now, I'm trying to do the exact same thing with a numeric entry field in a dashboard prompt, and I'm running into a stumbling block. I want to type a number into a field in a dashboard prompt, and populate a session variable called Change_Pctg. Selecting "Variable Prompt" in the dashboard prompt only lets me populate a Presentation Variable. But no matter. I've created a "dummy" field like we used to do in 10g, just creating a Column Prompt against a column formula of 1.
When I put the analysis onto the dashboard, it's correct. I can enter a number into the dashboard prompt field, click Apply, and that value is shown in the analysis on the screen. I'm filtering against that value as well, and the number of rows is right. So I know that I'm setting the value of that Change_Pctg session variable.
But when I click the action link, only Selected_Mo is respected by the target analysis. The Change_Pctg session variable is ignored.
Any thoughts?
I'd like to abort this post. I've been able to replicate the error using a much simpler method. Refer to the post entitled 'Passing Presentation Variables to Guided Navigation'.
Related articles
  • Using variables as filters in analyses launched by Guided Navigation links 10-11

    I'm trying to build a navigation link that will launch an analysis and have the filters in that analysis respect the values of either Presentation Variables or Session Variables. I'm having success with an ordinary column. I'm not having success with

  • Facing issue in PDF print on using Guided Navigation Link on dashboard 10-11

    Hi, I am facing one issue on using Guided Navigation Link on dashboard. I have created one Guided Nav. Link on dashboard and renamed it as "RAW DATA". It was working fine.It is coming as RAW DATA link and when I am clicking on the link it is dri

  • Passing Presentation Variables to Guided Navigation 11-30

    I'm having trouble passing Presentation Variables (and Session Variables) to analyses called via a Guided Navigation link in 11.1.1.5. 1. Created a dashboard prompt to select from a list of months. The prompt populates a Presentation Variable called

  • Passing Variable to air app when launch using Badger 10-11

    Hi all, I am going to desperately to develop my application. Hope someone can help me........ I am using badger for air which I get it here http://www.adobe.com/devnet/air/articles/badger_for_air_apps.html and it launch my app correctly, but I can't

  • How can we use Session Variable in Answers or Analysis? 11-30

    How can we use Session Variable in Answers or Analysis?Again, duplicate cross-posting! See rukbat 's post here: Re: BI Apps 7.9.6.3(Agent Issue)Read other 2 answers

  • Using Same Request with prompted filters in Guided Navigation 10-11

    Hi Gurus, I have a requirement wherein i have to show a report only when it returns results. For this i put the request in a section and applied a guided navigation using the same Request as source Request. Can i use the same request in the guided na

  • Using variables in the title of the graph 10-11

    Hi Gurus, I would like to use - for example a presentation- variable in the title of a graph. I assign a value for that variable in dashboard prompt. Does anybody know the syntax of using variable in the title of a graph (Not in a Title view!) Thanks

  • How do i filter the records in analytic view by using variable/parameter for a time range 10-11

    i have a analytic view which has a output column as date type. i want the user who use this view have the control to decided the output records based on a time range (from x to y). i tried to create 2 variables, 1 for start_time, 1 for end_time. Idea

  • How to use "Reference Structure" setting in analysis grid item 10-11

    Hello expert,         in Bex analyzer, how to use "Reference Structure" setting in analysis grid item by example? Many thanks,The variable needs assigned a value, that's why you're getting prompted. When you execute the statement, it's not execu

  • Use variables in a SELECT INTO FROM command 11-30

    Hi, How do I use variables within a select into from command? I want to loop through SYS.DBA_TABLES using a cursor and count the number of rows in a selection of tables an then insert into a cardinality table. The count of rows will be stored in a va

  • Structure data in the spreadsheet using BEx Query filtered by year 11-30

    Hi, I´m making a Balanced Scoredcard using Xcelsius and extracting data from SAP BI.   The customer asked to see a few KPI´S (Return on assets and profit margin) filtering data from the dashboard by year,  month and region. The problem I´m facing is

  • How to use variable in rule script in HFM 11-30

    I'm now writing VB script for HFM rule, and have something to ask about the use of variables in rule. The script below generates the following error. -Error description- Line: 4, Error: Invalid Expression HS.Exp "S#Actual.A#77300.I#[ICP None] = cur&q

  • I am using Photoshop as external editor but can't use all the filters 11-30

    Hi, I have just started using Aperture and have set-up photoshop CS2 as the external editor. I'm trying to add film grain to some of my images using the artistic filters. If I open one of my RAW (EOS 5D) images in Bridge once open in CS2 all the filt

  • Error-Receiver File Adapter using Variable substitution when file is empty 10-11

    XI Experts, We are on PI 7.0, SP14. We are using variable subtitution to get the filename from source message. This works fine as long as we have data in the payload for filename element. But we have a scenario where we don't have to create file when

  • Using variables to insert data in the table 10-11

    I want to insert datas in the table. I use constants, all the constants are stored properly in the table. But, when I use variables I get the error message "Too few parameters. expected 6". (I declared all the fields of the table as text only.)

  • Using variable with the same name as field name? 10-11

    I have a complex proc where I have variables with the same name as field name used on a query. something like this: SELECT a.id_table WHERE a.id_table = id_table where the last id_table is a parameter sent to the proc: declare procedure myproc(id_tab

  • How to use variables with 10-11

    I need to get the number of lines in internal table, which would be easy, using DESCRIBE TABLE itab LINES lines. But the problem is, that I get the name of this internal table in the field of another internal table, so I have to use the name of inter

  • How to use variables in data slices? 10-11

    Hello, in BI-IP I have tried to use variables in a data slice. The user should fill these variables. How can one use and fill these variables? Thank you DanielHello Horst, data slice is a very strong system lock. It is normally not a good decission t

  • White lines generateds in a File Adapter when using variable substitution. 10-11

    Hi all, I have been a problem in File generated by XI, my File Adapter is using variable substitution with reference to a field of my message type. Because it, the files generated has white lines in top of file. What can I do to not apears these line

  • Using variable of one  class in another class 10-11

    what are the different ways in which we can access a variable defined in one class in some other class ,i am aware of making object of that class and using variable ,inheritance polymorphisms,is there any other waylearnerpuneet wrote: i don't want to