• RELEVANCY SCORE 3.87

    DB:3.87:Re: Presentation Variable Issue On Drill Reports Of Title View 1m




    Dear guys,

    Please help me on this issue.

    Thanks in advance.

    Regards,
    Samdev.

  • RELEVANCY SCORE 3.85

    DB:3.85:Re: Presentation Variable Issue 8z




    hi,
    For presentation variables we cant set the data type

    DB:3.85:Re: Presentation Variable Issue 8z

    user,
    modify the sql/report to get it filter with presentation variable

    can u give some default value and try

    CAST(@{var_p}{4} AS INT)( where 4 is ur value) and preview it in answers

    Thanks,
    Saichand.v

    Edited by: Saichand Varanasi on Nov 9, 2010 10:21 AM

  • RELEVANCY SCORE 3.75

    DB:3.75:Re: How To Display Column Selector Value In Report Title 7a




    try this....

    http://santoshbidw.wordpress.com/2011/05/31/presentation-variable/

    Thanks

    kavi

    DB:3.75:Re: How To Display Column Selector Value In Report Title 7a

    @David, Nope I am not, i was having a similar issues and was following the post...

  • RELEVANCY SCORE 3.62

    DB:3.62:Re: How Do I Retrieve Distinct Values In A Multi-Column Presentation Variable 7x


    Hello -

    I have a similar error comment.

    My prompt has 2 columns (say brand_name, model_name) allowing mulitiple values and containing presentation variables. In my answers, I am checking the value of the presentation variable.

    case when @{brand_name} = 0 then Model_name when @{model_name} not = 0 then brand_name end

    This is the only place I am using the presentation variable. Now, when I select multiple value in the prompt, it gives me the error 'The number of columns returned in retrieving column metadata was invalid' ..

    Any help would be appreciated.

    Thanks !

    Edited by: 958402 on 13-Mar-2013 11:23 AM

    DB:3.62:Re: How Do I Retrieve Distinct Values In A Multi-Column Presentation Variable 7x

    Yes Jason thats what I did. Created a Column prompt with presentation variable. Request had 'is prompted' for the prompt. Used the presentation variable in a column. The key to it working was, I did not have a column with only the presentation variable. And the formula in the column was

    CASE WHEN '@{pvarModel}{NOSELECTION}' = 'NOSELECTION' THEN "Brand"."Brand" ELSE "Model"."Model" END

    It is important to have the single quotes around @{pvarModel}{NOSELECTION} . This helps when multi-value is selected in the prompt.

    Everything is working for me well. Thanks for all your help Jason !!!! I have no ways in this thread to mark all your responses as helpful. Am sorry about that !

  • RELEVANCY SCORE 3.57

    DB:3.57:Re: Dashboard Issue 7s


    Create presentation variables in prompts and use them as filter with some default values which returns No Results.

    or

    put prompts,Reports in different sections and use section guided navigation with one dummy column using PS variable value. .so when this Dummy column Returns any rows then only your Report will visible

    DB:3.57:Re: Dashboard Issue 7s

    Hi Experts,

    Edited by: user10675696 on Aug 31, 2012 4:58 AM

  • RELEVANCY SCORE 3.52

    DB:3.52:Slow Performance - 7z


    Dear all,

    I have a report where four filters in same column, we have use presentation variable for the filter, report run perfectly and data also correct.
    But problem is , report is very very slow if we use the presentation variable.

    Need your help to release from slowness.

    @zia

    Edited by: oraclezia on Apr 9, 2012 3:08 PM

    DB:3.52:Slow Performance - 7z

    Dear all,

    I have a report where four filters in same column, we have use presentation variable for the filter, report run perfectly and data also correct.
    But problem is , report is very very slow if we use the presentation variable.

    Need your help to release from slowness.

    @zia

    Edited by: oraclezia on Apr 9, 2012 3:08 PM

  • RELEVANCY SCORE 3.43

    DB:3.43:On Presentaion Variable 19


    Hi

    We have a problem with presentation variable.

    Scenario: We are using a presentation variable in the columns in 2 cases

    *1. CASE WHEN column_name=presentation_variable THEN x ELSE y END*

    *2. CASE WHEN column_name=presenation_variable THEN x else y END.*

    In the case 1: We are able to pass the presention variable when we give prompt value

    In the case 2: We are unable to pass.

    That is when we use either greater or less than symbol presenation variable is not passing.
    Do we need to give any option to make it pass.

    Can you please help me out on this issue

    Thanks

    Subhash

    DB:3.43:On Presentaion Variable 19

    if the declaring of syntax is right then you should have any problem in either of the cases. It works for me in both the cases,

    case when Times."Calendar Month Number"='@{monthVar}' then Times."Calendar Month Number" end
    case when Times."Calendar Month Number"='@{monthVar}' then Times."Calendar Month Number" end

  • RELEVANCY SCORE 3.43

    DB:3.43:Re: How To Create New Calculated Column Based On Filtered Columns? f8


    Try by using (col1/col2*100) as it is. Please use some default values like @{Presentation Variable}{Default Value}.

    DB:3.43:Re: How To Create New Calculated Column Based On Filtered Columns? f8

    Hello MK,

    I have a tried following formula. It is working, but result is not filtered.

    I filtered "PAYMENTS"."SUM_PAY_AMOUNT" and "DW"."SUM_PLAN_MONTH_AMOUNT" columns.

    "PAYMENTS"."SUM_PAY_AMOUNT" / "DW"."SUM_PLAN_MONTH_AMOUNT" * 100Can you share me some tutorial?

    BR,
    Eba

    Edited by: Erdenebayar on Apr 19, 2012 3:43 PM

    Edited by: Erdenebayar on Apr 19, 2012 3:43 PM

    Edited by: Erdenebayar on Apr 19, 2012 3:43 PM

  • RELEVANCY SCORE 3.38

    DB:3.38:Dashboard Prompt - Need Urgent Help ff


    When I want to create dashboard prompt with two prompts, on the same column, it won't work. I am using presentation variables for filtering.

    Example:
    in some prompt
    i use hire_date equal to some presentation variable x1, and
    also hire_date equal to some presentation variable x2,

    and then I am sending this variables in some report when i want to filter on column, and say x1=hire_date = x2.

    But this prompt is not working.... it cannot work if you use one column and want to make equal that column with two presentation variables...

    I really need urgent help... I stack here...

    DB:3.38:Dashboard Prompt - Need Urgent Help ff

    I did it, but didn't help... all my prompts has a scope on page, but still have problems with the ''repeating columns'' in prompts

  • RELEVANCY SCORE 3.36

    DB:3.36:Re: Prompts 3d


    Hi,

    Is that prPrompt , a presentation variable of the column.

    I tried but its showing syntax error near @ symbol.

    Can u please solve it

    DB:3.36:Re: Prompts 3d

    ........ Check last entry........

    Edited by: John Minkjan on Sep 20, 2011 1:23 AM

  • RELEVANCY SCORE 3.31

    DB:3.31:Passing Presentation Variable's Value Through A Dashboard Link dk


    Hi,
    I am using a Presentation Variable which gets the value from a prompt. When i use this Presentation Variables value through different pages for prompting, i am getting the result.

    But, When i use the link (Dashboard Link which navigates to other Dashboard Page), I am not getting the result (value of the Presentation Variable is not prompted).

    Plz, help me in this.

    Thanks in advance,
    Ram Mohan T.

    DB:3.31:Passing Presentation Variable's Value Through A Dashboard Link dk

    Hi,
    I am using a Presentation Variable which gets the value from a prompt. When i use this Presentation Variables value through different pages for prompting, i am getting the result.

    But, When i use the link (Dashboard Link which navigates to other Dashboard Page), I am not getting the result (value of the Presentation Variable is not prompted).

    Plz, help me in this.

    Thanks in advance,
    Ram Mohan T.

  • RELEVANCY SCORE 3.31

    DB:3.31:How To Cast Presentation Variable 1z


    Hi,

    How to cast the presentation variable in answers

    Thanks in advance

    naresh

    DB:3.31:How To Cast Presentation Variable 1z

    Hi Naresh,

    Have you tried to use the CAST function?

    CAST(@{test}{123} as char)

    With the above column Formula in Answers Request I can able to view the result 123, which is the default value specified the presentation variable 'test'.

    Hope this will helps you..

    -Vency

  • RELEVANCY SCORE 3.29

    DB:3.29:Presentation Variable In Column Formula 8p


    Can I use presentation variable only in Column Formula?

    DB:3.29:Presentation Variable In Column Formula 8p

    Hi,yes u can use presentation variable in column formula..Please refer this below link...OBIEE Qamp;amp;A: OBIEE 11g: Presentation Variable initialization in a Multi-Select Prompt OBIEE - Where can I use a presentation variable ? | GerardNico.com (BI, OBIEE, OWB, DataWarehouse) Please mark if it helps you......Thanks...

  • RELEVANCY SCORE 3.29

    DB:3.29:Request Variable And Presentation Variable z9


    Can anyone tell me about the
    difference between request variable and presentation variable in OBIEE

    DB:3.29:Request Variable And Presentation Variable z9

    Wrong forum.
    Try:
    Business Intelligence Suite Enterprise Edition

  • RELEVANCY SCORE 3.29

    DB:3.29:Re: How To Display Prompts Value In Report Title m1


    Have a look here:
    http://obiee101.blogspot.com/2008/02/obiee-adding-session-variables-to.html
    or
    http://debaatobiee.wordpress.com/2009/09/29/using-repository-session-and-presentation-variable-in-titlesubtitlenarratives/

    regards

    John
    http://obiee101.blogspot.com

    DB:3.29:Re: How To Display Prompts Value In Report Title m1

    You need to understand that there are three types of variables: session, repository and presentation.

    What you want to do is use Presentation Variables. These can be set using Dashboard prompts. Look at my previous post and I describe how to set it. Once set you can put it in your Title View, a Narrative View or even in a column in your report.

    I think you need some basic help in getting around OBIEE. Take a look at this link. Oh, but before you do that, it would be nice to give points to all the people that responded and gave you some "helpful" tips. Look at the top right of each post; you can mark it there.

    Now look at this link for a tutorial in how to use OBIEE. There's a part on how to set up Presentation Variables. Good luck!

    http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/saw/saw.html

  • RELEVANCY SCORE 3.29

    DB:3.29:Conditional Filter With Presentation Variable? 8k


    Hi all,

    I have a report in which I filter sales assessment templates name (surveys). I would like to be able to apply an additional filter if and only if a presentation variable has a value. The presentation variable is set via a prompt. I tried several times, but I was not able to achieve my objective. I tried to use a "CASE" statement in a SQL filter but no success :-(

    Can anyone help?

    Basically the thing is: IF variable not set (or equal to 0) THEN display all templates ELSE display only templates that end with variable number END

    DB:3.29:Conditional Filter With Presentation Variable? 8k

    I am trying to do something similar. Did this ever work for you?

    I have created a presentation variable prompt test which gives two radio buttons 1 and 2. The next prompt is a case statement

    case when @{test}{2}=2 then "table"."column name" else "table"."column name1" end

    But the filter from this prompt never gets applies. What am I doing wrong?

  • RELEVANCY SCORE 3.29

    DB:3.29:Date Between Using Presentation Variables In Obiee j8


    Hi Gurus,Can somebody help on how to pass Date using Presentation variable and using between operator ( like PV between Start_date and End_date )

    DB:3.29:Date Between Using Presentation Variables In Obiee j8

    Hi Gurus,Can somebody help on how to pass Date using Presentation variable and using between operator ( like PV between Start_date and End_date )

  • RELEVANCY SCORE 3.20

    DB:3.20:Get First Day Of A Week f7


    Hi all,

    I have a question about using a presentation variable in a sql filter.Actually i have a presentation variable which return number of week per year ,the issue is that i want to have the firste day of the week selected in way to use it in the sql filter .

    Thanx for help

    DB:3.20:Get First Day Of A Week f7

    Thanx for your reply but i don't see any difference betwwen the two formulas ??

  • RELEVANCY SCORE 3.20

    DB:3.20:Can Some One Tell Where In Obiee Presentation Variable Value Get Stored? fa


    Can some one tell where in OBIEE presentation variable value get stored?

    DB:3.20:Can Some One Tell Where In Obiee Presentation Variable Value Get Stored? fa

    Can some one tell where in OBIEE presentation variable value get stored?

  • RELEVANCY SCORE 3.17

    DB:3.17:Variables 8p


    can anyone help me with this question. what is the purpose of using variables in real time what is the different between each variable in real time either repository session presentation request variable Thanks in advance

    DB:3.17:Variables 8p

    Questions from your Interview?read Help file from BIThanks,http://cool-bi.com

  • RELEVANCY SCORE 3.17

    DB:3.17:How To Send Presentation Variable To Other Report? c9


    I've a date presentation variable d_pv in dashboard prompt. In dashboard I've a Master Report, from where I need to navigate to Detail report. Detail report should be filtered on the (selected date - 1) from the prompt. I'm able to pass the d_pv value to detail report but I need to filter detail report one day back from the value of d_pv.

    Appreciate your help.
    Thanks

    DB:3.17:How To Send Presentation Variable To Other Report? c9

    Hi Saichand,
    I changed the fileter as you told me [TIMESTAMPADD(SQL_TSI_DAY,-1, DATE '@{d_pv}')]
    But I'm getting the following error.

    [nQSError: 46047] Datetime value @{d_pv} from @{d_pv} does not match the specified format.

    I checked and the presentation variable is coming in 'YYYY-MM-DD' formatThanks

  • RELEVANCY SCORE 3.16

    DB:3.16:Re: How To Filter Values Using Presentation Varible If It Is Using A Multiselec sp


    Hi,
    If you select the multiselect in the dashboard pormpt,you cant assign that value to a presentation variable in obiee 10g.

    mark if helpful/correct...

    thanks,
    prassu

    DB:3.16:Re: How To Filter Values Using Presentation Varible If It Is Using A Multiselec sp

    The functions applied on columns need to be both places (in report and prompt ) and need to set is prompt after the function apply in the report.

    In your case is prompt is set before cast it seems that's the reason it's not working.

    Pls mark correct/helpful if helps.

  • RELEVANCY SCORE 3.16

    DB:3.16:Set Presentation Variable Using External Javascript? 71


    I want to create a user defined filter using custom java-script drop-down and wish to set a presentation variable on the dashboard. I have looked into various JS files to find the method for setting a presentation variable but have failed badly. If there is a way to set this variable please do help me out.

    thanks in advance
    ~V

    Edited by: user4555163 on Mar 9, 2011 5:42 PM

    DB:3.16:Set Presentation Variable Using External Javascript? 71

    Provide js-library you found and method for setting pres. variables and your custom js code.

  • RELEVANCY SCORE 3.16

    DB:3.16:Re: Passing Prompt Value To Column Header fd


    Hi.

    This is not the best solution, but check:
    http://oraclebizint.wordpress.com/2008/01/25/oracle-bi-ee-101332-dynamic-column-headers-using-presentation-variables-sets-and-conditional-formatting/

    The ideal situation will be when we could put a variable in the column header.

    Try searching the google or forum.

    Regards
    Goran
    http://108obiee.blogspot.com

    DB:3.16:Re: Passing Prompt Value To Column Header fd

    Hi,

    Yes. you can do that by creating presentation variable.

    What you have to do is , create the presentation variable like LOCATION_NBR in the prompt, like this you can create as many as you want to display it in the header.

    The next step is to display the value the user selects in the prompt that should display in the header, for that , you can create narative and like the following things and achieve it.

    table
    tr
    td bgcolot ="#00080" width="1500" height="25" align="center"
    The location No is @{LOCATION_NBR}
    /td
    /tr
    /table

    Since we define the presentation variable in Prompt and use it narative view we able to display the header based on the customer choose it from prompt

    I hope the above explanation will resolve your requirement

    Regards
    Raj

  • RELEVANCY SCORE 3.15

    DB:3.15:Re: Access Presentation Variable In Javascript d7


    http://www.catb.org/~esr/faqs/smart-questions.html#goal

    DB:3.15:Re: Access Presentation Variable In Javascript d7

    Dear Vetsrini, if you are going to edit your posts and remove everything in them then don't waste out time and don't bother posting at all.

  • RELEVANCY SCORE 3.15

    DB:3.15:Re: Change Presentation Variable Value xj


    presentation variable value is not like repository/session variable to change it's value..

    it will be defined in dashboard prompt and it holds selected value from the dashboard prompt...
    if you want to know what values it's containing by, we've many ways..

    check this:
    http://bischool.wordpress.com/2009/05/05/presentation-variable-values-in-report-titles-or-using-presentation-variable-in-dashboard-text-object-and-narrative-view-directly/

    DB:3.15:Re: Change Presentation Variable Value xj

    Hi,
    Thank you very much for your valuable responses. Actually the solution whatever you have given is the correct one.
    Thanks once again.

    Regards
    Niranjan Kumar.D

  • RELEVANCY SCORE 3.14

    DB:3.14:Date Format In Presentation Variable sk


    Dear Guru,

    My prompt has a calendar month edit box which is in "YYYY / MM" format. I have set this as a presentation variable p_month.

    Now I need to add 1 month to this presentation variable in the filter, I have tried to write the sql but it is complicated, and it does not work. Anyone could help?

    Thanks a lot,
    Joe

    DB:3.14:Date Format In Presentation Variable sk

    O...Thanks,

    this method works!

    Really thanks.

  • RELEVANCY SCORE 3.13

    DB:3.13:Re: Misuse Of Static Variable...Need Some Help dd


    in short fileName variable should not be declared static for clean result

    DB:3.13:Re: Misuse Of Static Variable...Need Some Help dd

    shet wrote:
    To make clear,I am not using thread per se (Thread)...I mean the main thread ...and I am not spawning any new thread programaticallyYou explicitly mentioned two separate threads in your initial post. That's why I thought there were multiple threads involved.

  • RELEVANCY SCORE 3.12

    DB:3.12:Presentation Variable And Date Substraction c8


    Hi ,I created presenation variable called "DATE" and I want to substract years, months, dates from this presentation variable DATE. Imagine DATE gives default current date value and from this extract years , months, dates and do perform substraction, addition etc. '@{DATE}[YYYY]' gives current year value.How do I substract 1 year from this.OBIEE gurus help earliest.Advance thanks for OBIEE gurus.

    DB:3.12:Presentation Variable And Date Substraction c8

    Check this URL ,, It wil solve all your problems http://obieeil.blogspot.in/2014/02/obiee-prompts-last-year-last-month-and.htmlThanksAJ

  • RELEVANCY SCORE 3.12

    DB:3.12:Pass Presentation Variable To Kpi 1x


    Hi,

    I am using Oracle Obiee 11.1.1.6.8 and I have a problem with pass Dashboard prompt value, captured in presentation variable, to KPI (Actual Value and Target Value).

    I have put in the same dashboard:
    -Dashboard Prompt (with a prompt presentation variable)
    -KPi WatchList
    -Analysis (with the same Column formula used in KPI)

    While the analysis is displayed correctly (the amount calculated corresponds to the filter applied), the KPI WatchList displays the amount applying filter as the default value of presentation variable instead of the value from the prompt.

    Can anyone help me on this matter ?

    Thanks in advance

    Manuela

    DB:3.12:Pass Presentation Variable To Kpi 1x

    Hi,

    I am using Oracle Obiee 11.1.1.6.8 and I have a problem with pass Dashboard prompt value, captured in presentation variable, to KPI (Actual Value and Target Value).

    I have put in the same dashboard:
    -Dashboard Prompt (with a prompt presentation variable)
    -KPi WatchList
    -Analysis (with the same Column formula used in KPI)

    While the analysis is displayed correctly (the amount calculated corresponds to the filter applied), the KPI WatchList displays the amount applying filter as the default value of presentation variable instead of the value from the prompt.

    Can anyone help me on this matter ?

    Thanks in advance

    Manuela

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Need Help On Environment Variable dk


    See my previous post :)

    /Kaj

    DB:3.10:Re: Need Help On Environment Variable dk

    I'm not using 1.5. I'm not sure that this method is a compelling reason to switch, especially since getProperty works just fine.

    %

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Presentation Variable In Rpd 8x


    You create an extra session variable to capture the value of the request variable. And this 'new' session variable can be used within your rpd...should work

    Kr,
    A

    DB:3.10:Re: Presentation Variable In Rpd 8x

    Hi,

    Did you got any resolution to this issue. We are also having the same issue(select value from prompt and that value need to be in some variable and then this variable neeed to be refer in rpd) in our current client. It will be great if you can share some ideas regarding this.

    Thanks,
    Sandy.

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Set Session / Presentation Variable In Repository Variable s7


    Hi All,
    I want to call a function after dashboard prompt selection . In the function i want to pass a parameter which will come from dashboard prompt.

    In the RPD , i am passing a repository variable to the function as a parameter.

    I am calling the function in a intermediate report by using evaluate function.

    If any way i will be able to pass dashboard prompt value to the function then i think i can achieve my goal.

    Is there any way to set session or presentation variable in repository variable. Please help...

    DB:3.08:How To Set Session / Presentation Variable In Repository Variable s7

    If you wan't to make function call with evaluate method in the RPD logical column then:
    1. Make non-system session variable in the RPD
    2. Make initialization block (for example select 'Value' from dual)
    3. Make logical column in RPD using evaluate function call with parameters
    EVALUATE('my_function(%1)' as char, VALUEOF(NQ_SESSION.YOUR_NONSYSTEM_SESSION_VARIABLE))
    this logical column will take the value that this function returns
    4. Make Answers report with this column and dashboard prompt which set non-system session variable in the Set Variable/Request Variable.

    If you wan't to make function call with evaluate method in the Answers only:
    1. Make dashboard prompt and set presentation variable
    Set Variable/Presentation Variable.
    2. Make Answers report and write evaluate expression in the column
    EVALUATE('my_function(%1)' as char, '@{your_presentation_variable}')
    in this case presentation variable is character

    Regards
    Goran
    http://108obiee.blogspot.com

  • RELEVANCY SCORE 3.06

    DB:3.06:Re: How To Use Presentation Variable 9m


    if you have a presentation variable use a advanced filter with TIMESTAMPADD/TIMESTAMPDIFF functions appropriately.
    i.e. date BETWEEN TIMESTAMPADD(....@{presentationvar}) AND @{presentationvar}
    caveat: date is not accepted as argument to TIMESTAMP functions, thus convert them to timestamp

    -bifacts
    http://www.obinotes.com

    DB:3.06:Re: How To Use Presentation Variable 9m

    Hi,
    Check this....Its a good example on presentation variable....Using it for report title and to filter data in report....
    http://bischool.wordpress.com/2009/05/05/presentation-variable-values-in-report-titles-or-using-presentation-variable-in-dashboard-text-object-and-narrative-view-directly/
    About presentation variable....http://gerardnico.com/wiki/dat/obiee/presentation_variable

    Please be specific...do close your thread...if its answered...

    Regards,
    Srikanth

  • RELEVANCY SCORE 3.06

    DB:3.06:Presentation Variable For In Between Date Prompts 8m


    Hi,

    I have a requirement where I need to pass value to presentation variables for "In between" date prompts.

    Basically a user can select two dates from the same column and see the revenue between those dates.

    The problem is that I can use one column only once and if I do "In between" then the "set variable" option is gone.

    Kindly help me with the issue.
    Thanks.

    Vinay

    DB:3.06:Presentation Variable For In Between Date Prompts 8m

    Now we debug. First test the prompt itself. Does it work in the dashboard? Do you see the values you expect? What is the format? Timestamp or Date or CHAR?

    If that works then test the Request itself. Do you have at least one column that is not a "dummy" column? If not, you will get the "unresolved" error. If that is okay, add a default date after the PV in the filter:

    Now see if the report renders meaningful values.

    Report what you see.

  • RELEVANCY SCORE 3.06

    DB:3.06:Re: Presentation Variable - Help 8z


    Ed,
    Could you use the timestampadd function in the column formula instead, so your variable filters it to say 2008, the function in the formula will then make it appear as 2007?

    regards
    Ed

  • RELEVANCY SCORE 3.06

    DB:3.06:Re: Multiselect With Presentation Variable 9x


    Hi Naresh,

    my actual requirement is, i need multiselect for all the columns. How to achieve in this case?

  • RELEVANCY SCORE 3.05

    DB:3.05:Presentation Variable 7k


    Can anyone help me with this issue

    I have one report requirement which contain one dashboard prompt on Year. this is my presentation variable.
    Based on this i want to pull the sales volume of selected year and its previous year.

    Ex- if user select year=2009 then I should show Sales Volume of Current year(2009) and in another column i want Sales Volume of 2008.

    Any help would be appreciated!

    Thanks.

    DB:3.05:Presentation Variable 7k

    Hi,

    You can achieve this using pivot table. Capture selected year in presentation variable say var1 and put filter on year between (var1-1) and var1. Now you have two years sales volume data in the report and then generate pivot view by putting year in column section.

    ~Karbhari

  • RELEVANCY SCORE 3.05

    DB:3.05:Question About Passing Presentation Variable In A Column kp


    Hi All,

    I am passing a presentation variable in a column . The variable is a number. i am using the level 0 of the flattened hierarchy for this. However, what i am looking for is passing the variable and showing the next column from the flattened hierarchy.

    Example :

    Variable value = 1
    it should display level 2 from the hierachy.

    if Variable Value = 2
    then it should display level 3.. so on and so forth.

    What is the way to do this.

    ANy help will be appreciated.

    thanks

    DB:3.05:Question About Passing Presentation Variable In A Column kp

    Hi All,

    I am passing a presentation variable in a column . The variable is a number. i am using the level 0 of the flattened hierarchy for this. However, what i am looking for is passing the variable and showing the next column from the flattened hierarchy.

    Example :

    Variable value = 1
    it should display level 2 from the hierachy.

    if Variable Value = 2
    then it should display level 3.. so on and so forth.

    What is the way to do this.

    ANy help will be appreciated.

    thanks

  • RELEVANCY SCORE 3.04

    DB:3.04:Presentation Variable Issue 1x


    Hi

    im using presentation variable to filter the data but that filter is based on the default value only

    im using another filter but it give wrong data

    plz help

    DB:3.04:Presentation Variable Issue 1x

    973629 wrote:
    but that filter is based on the default value onlyWhat does this mean?

    Please provide details of your analysis/query and environment and someone should be able to help you here.

  • RELEVANCY SCORE 3.03

    DB:3.03:Problems In Navigating From One Report To Another In Obiee 10g mc


    Hi,

    I am trying to navigate from One report another report.
    In the first report, the filters are being passed using the presentation variable.
    In the second report, the filter are also based on presentation variable.

    In the first report, filters are being passed but when I navigate to second report I face the problem.
    The presentation variable are not getting passed.

    Kindly help with you suggestions.

    Regards,

    Biswadeep

    DB:3.03:Problems In Navigating From One Report To Another In Obiee 10g mc

    Hi Biswadeep,

    in your first report you use the presentation variables to filter data. But in your second report, you must include all fields where you want filter data and in the properties of each field you indicate that these fields are prompted.

    Hope it helps,

    Benoit

  • RELEVANCY SCORE 3.03

    DB:3.03:Multi Select Box Does Not Refresh With Presentation Variable xd


    Hi All,
    I have two dashboard prompt. sencond dashboard prompt is having multi select option and to populate multi select box i have a sql query which uses a presentation variable from first dashboard promt. But here what i face is the moment i use a presentation variable in the sql query of multi select box it is not fetching any record. It does not replace the presentation variable with actual value. if i'm changing it to drop down box then same query works fine.

    Is there any way to solve this issue for multi select box ??

    Please help if anybody knows .

    DB:3.03:Multi Select Box Does Not Refresh With Presentation Variable xd

    user12077461, you didn't understand the problem. We cann't assign our choosing to presentation in multi select box. It's a clearly. But we want to use presentation variable in a SQL query for multi select box. And it's a problem.

  • RELEVANCY SCORE 3.03

    DB:3.03:Re: In Obiee 11g, How Can You Set A Presentation Variable Value From Javascript ? d8


    SriniVEERAVALLI,Thanks for your suggestions. I want to make a custom prompt that is only my requirement. From JS I have made a custom slider prompt now I want to use this slider prompt to pass selected value in presentation variable. Since, we have slider prompt only for numbers, I have to use it for other values. I just want to make my post looks simple and focus on the specific problem.Anyways, thanks a lot for taking time to reply. Appreciate your help.

    DB:3.03:Re: In Obiee 11g, How Can You Set A Presentation Variable Value From Javascript ? d8

    Thanks GRK,I need to set a presentation variable without using GO Url method. But, let me see your code for presentation variable and if I could come with some workaround with that. My email is khadka.sajan@gmail.com

  • RELEVANCY SCORE 3.02

    DB:3.02:Re: Obiee 11g - Please Help, Having Real Problems With Saved Filters 3c


    Hi Scott,If all the dimensions are shared/conformed between the separate subject areas, look into using presentation variables. You won't be able to include a saved filter from one subject area into another... but you'll be able to re-use that presentation variable in each of your filters.Thanks,Jason

    DB:3.02:Re: Obiee 11g - Please Help, Having Real Problems With Saved Filters 3c

    Jason, thank you for the clarification.I really understand that this is a deficiency of OBIEE and will open a CR in Oracle for this to be reviewed and perhaps a solution close to our need to be given.Thanks again,Fernando.

  • RELEVANCY SCORE 3.02

    DB:3.02:Re: Em Configuration Issue s8


    @hans: Wouldn't help setting ORACLE_HOSTNAME variable to localhost?

    DB:3.02:Re: Em Configuration Issue s8

    Follow second part of Mr. Jean-Valentin's suggestion:

    And if it doesn't work it could be recreated like that:emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create:p

  • RELEVANCY SCORE 3.02

    DB:3.02:Capture Dates Vales Selected From Date Prompts Using Presentation Variable pp


    We have a requirement of displaying the date on the report/text whatever the user selects the date from the prompt.
    We have a date called creative date and operator used is between .
    Can anybody help me in this, how to use presentation variable to capture the values of a single column -Creative Date ?

  • RELEVANCY SCORE 3.01

    DB:3.01:How Do I Re-Apply Presentation Template fj



    I have 200+ Contents that I wanted to re-apply existing presentation template so that new rendition file will be generated. It will be tedious if I try them from Web Publisher. Is there way I can use API or DQL command to do so? Appreciate any help

    thx

    -amitav

    DB:3.01:How Do I Re-Apply Presentation Template fj


    I wrote about this here: http://robineast.wordpress.com/2009/02/03/webpublisher-apply-presentation-from-the-command-line/

    This applies to web publisher 5.3, I assume it still applies to later versions .

  • RELEVANCY SCORE 2.99

    DB:2.99:Re: Accessing Session Variable Inside Presentation Variable pm


    Hi Deepak,

    sorry that was a typo, i wanted repository variable.

    Thanks,
    Sreekanth

    DB:2.99:Re: Accessing Session Variable Inside Presentation Variable pm

    Well, I have couple of soln for this ..Basically you require 13 month rolling trend.
    Refer http://shivabizint.wordpress.com/2008/09/19/rolling-months-data-for-year-month-prompt-in-obiee/ and 13 for rolling no.
    OR
    Create a Mid report which give you 4 values like
    2011 Sept-11 2010 Sept-10
    And then filter your main report month column based on this Mid report month cols

    Hope this is clear

  • RELEVANCY SCORE 2.99

    DB:2.99:Re: Help For Newbie Beginner (Arrays) fm


    In this case it would be the variable "entered" then?

    DB:2.99:Re: Help For Newbie Beginner (Arrays) fm

    well this person when they posted were new to the
    language. This would be a time when readability is
    very important. Like in elementary when you began
    learning order of operations you had to bracket what
    calculations are done first.

    You don't need the additional parenthesis just like
    you don't need to indent but if it makes it easier to
    read for a beginner it is a good practice. It also
    makes certain things happen as you expect them to...
    in this case it would not have mattered but sometimes
    without parenthesis a test statement can get mighty
    wild looking.Fair enough. I was reading too much into the word need.

    I agree that readability is critical. Although personally I wouldn't adopt parenthesis in this instance - but that's a style issue, and everyone should adopt the style with which they are most comfortable (to a certain extent....)

  • RELEVANCY SCORE 2.98

    DB:2.98:How To Pass Presentation Variable Value From Main Report To Detail Report kk


    Hello,

    I've 2 reports that is attached to each other. In my main report i've several report prompts and i am using i"s prompted" on my detail report to attach them.

    But 2 of my report prompts are presentation variables(Names : FIRST, SECOND). Both are in date format. I've a filter in my main report like;

    "ASSIGNMENTS_F"."EFFECTIVE_START_DATE" BETWEEN @{FIRST} AND {SECOND}

    It works fine when i run the main report. But when i click on the numbers, i see that i can not filter my detail report with the chosen values for 2 presentation variables. It just shows all the dates.

    I've tried adding both presentation variables in both reports as columns and adding 'is prompted' filter to them. But did not work either.

    I just cant pass the written values for presentation variable prompts to detail report..

    Please help :)

    DB:2.98:How To Pass Presentation Variable Value From Main Report To Detail Report kk

    Hi,

    What you can try is refer the filte condition in the main report to the detailed report with the option-- Filter based on another request.
    Or you try creating another intermediate report which will refer the main report filters and pass the filters to the detailed report.

    Hope this helps.

    Regards
    MuRam

  • RELEVANCY SCORE 2.98

    DB:2.98:Request Variable And Presentation Variable z1


    Can anyone tell me about
    difference between request variable and presentation variable in OBIEE answers.

    Edited by: Mervin on Feb 4, 2011 12:50 AM

    DB:2.98:Request Variable And Presentation Variable z1

    Hello Marvin,

    for request variable with example( a good post from Nico)

    http://gerardnico.com/wiki/dat/obiee/set_variable

    for presentation variable with example

    http://gerardnico.com/wiki/dat/obiee/presentation_variable

    Thanks a lot

    Please Mervin, close the threads if any of answer is helpful so that it can help other followers.

  • RELEVANCY SCORE 2.98

    DB:2.98:Re: Using A Variable Prompt - In An Analysis Using Top N Filter 7z


    from your expalnation above I didnt see any comments abt presentation variable did you created it..is that Number_of_rows is Presentation variable?

    DB:2.98:Re: Using A Variable Prompt - In An Analysis Using Top N Filter 7z

    I'll put this as below
    My prompt will have the TopN which can be formated by TopN Orders and setting this as Presentation variable as N
    SELECT TOPN("#Sales",10) FROM "SA" order by Product

    In the report I'm using same column (Orders) with expression as below.
    TOPN("#Sales", cast(@{N}{2} as int))

    If this is not helpful for you then try to pass some default value for the Presentation variable

  • RELEVANCY SCORE 2.97

    DB:2.97:Re: Calculate With Dashboard Prompt (Presentation Variable) 7z


    Oliver,

    If I m right,you are using two prompts (Year,Customerid) in first report.

    It seems that you are not passing Customer id filter value to second request.

    So,the idea is to pass values of both prompt to second request.

    Add these two more steps to the previous solution.

    1.In Customerid prompt for first request add presentation variable *"VAR_CUST"*

    2.In Second report edit Customerid column formula as

    *CASE WHEN 1=0 THEN CUSTOMER.CUSTOMERID ELSE @{VAR_CUST} END*

    Thats it.

    Regards,
    Amrita

    DB:2.97:Re: Calculate With Dashboard Prompt (Presentation Variable) 7z

    Great. You are very welcome, Oliver!

    I know you are a new user, so probably unaware, but Oracle (OTN) implemented new changes to this forum, one of which is a point system to award answers that have either helped you in some way or in fact, answered your question. If my answer solved your problem, you can thank the "answerer" by marking the "correct" link on the top right of my post. There may be others in this thread that you found gave you helpful answers. You can mark their post "helpful" as well. This gesture will be much appreciated by those who receive it and allows others to see who in this (and other forums) contribute answers.

    So...

    Step 1) Now that the thread is answered, assign points as appropriate.

    Step 2) Start a new thread with your new problem. Don't keep adding to one thread. It hinders those in the future who wish to search for a particular problem or issue.

    Step 3) Translate your code into English. Ich kann nicht verstehen Sie. Danke.

  • RELEVANCY SCORE 2.97

    DB:2.97:Re: Presentation Variables In Target Report cd


    NO. When you are using Go URL the presentation variables will not pass to your target automatically. You need to explicitly pass the variables in your GO URL.

    Even though the target report is in same dashboard the presentation variable will not be passed when using GO URL.

    DB:2.97:Re: Presentation Variables In Target Report cd

    But that is a promtp selected by the user in the dashboard.... we did not use the column anywhere....

    so i cant take the equivalent value... the only way is to use the variable and pass the value...

    My doubt is... as i can see the value being passed.. how a report can't catch it?

    Thanks
    Kiran

  • RELEVANCY SCORE 2.97

    DB:2.97:Re: Variable For 3 Previous Years sa


    Hi ,

    Try this :

    cast("YEAR column" as integer) in (cast(@{pv_year} as integer),cast(@{pv_year} as integer)-1,cast(@{pv_year} as integer)-2 , cast(@{pv_year} as integer)-3

    Make this as prompted , by selecting Advanced SQL filter and offcourse define a presentation variable ' pv_year ' .

    DB:2.97:Re: Variable For 3 Previous Years sa

    It may be done but there will be some not evident calculations. So it may the sankat approach optimal. Just create another session variable MONTH_3Y_AGO and use it.

  • RELEVANCY SCORE 2.97

    DB:2.97:Re: Prompt Stores Old Value In Presentation Variable cx


    Try to set the scope of prompt into 'Page'.

    DB:2.97:Re: Prompt Stores Old Value In Presentation Variable cx

    Hi,

    The abnormality, is that if i try to show presentation variable it has correct value!!!

    Have you had ever my same issue??

    Help me please!!!!!!!!

    Thanks

    Edited by: 832596 on 24-feb-2011 5.33

    Edited by: 832596 on 4-mar-2011 0.56

    Edited by: 832596 on 4-mar-2011 0.57

  • RELEVANCY SCORE 2.97

    DB:2.97:How To Pass Presentation Variable Values To Server Variables In View... jk


    Hi Experts,

    I am creating view in rpd based on SQL query ,but in that i am having different where clause for inner queries ,so my plan is like to get prompt values in presentation variable and then pass values to server variable in view.

    Can any one help me in this how to implement this.....

    Thanks,
    KSS.

    DB:2.97:How To Pass Presentation Variable Values To Server Variables In View... jk

    Hey KSS,

    What does your select statement syntax look like? Keep in mind that session variables behave different than a presentation variable. Presentation variables are immediately replaced by their representative value kind of like an MS Word find/replace. However, session variables are intelligently replaced in the sense if you session variable is a string, then OBIEE will wrap single quotes around the value.

    Here's two examples of how to use session variables. Assume PERSON_ID is VARCHAR2(20).

    Correct way to use session variable:

    SELECT *
    FROM PERSON_DIM
    WHERE PERSON_ID = VALUEOF(NQ_SESSION.PERSON_ID) --NOTE no single quotes

    Incorrect way to use session variable:

    SELECT *
    FROM PERSON_DIM
    WHERE PERSON_ID = 'VALUEOF(NQ_SESSION.PERSON_ID)'; --NOTE has single quotes

    Good luck!
    -Joe

  • RELEVANCY SCORE 2.97

    DB:2.97:Presentation Variable In Ibot kc


    Hi...experts....

    Can we use Presentation variable in iBot's?

    if possible, please explain

    DB:2.97:Presentation Variable In Ibot kc

    Hi,

    Refer this http://gerardnico.com/wiki/dat/obiee/presentation_service/obiee_presentation_variable_area

  • RELEVANCY SCORE 2.97

    DB:2.97:Re: How To Print A Request Variable In The Name Of A Section? 37


    Remco,

    anyone got suggestions for filling a presentation server variable when it is empty with a session variable?I didn't get you ?

    thanks,
    Saichand.v

  • RELEVANCY SCORE 2.97

    DB:2.97:Keynote Build Outs With Random Or Variable Sequence kx


    I need help in creating build outs that will work in a variable sequence when I click on the object. In my presentation I need to be flexible to the groups comments and questions.

    DB:2.97:Keynote Build Outs With Random Or Variable Sequence kx

    I need help in creating build outs that will work in a variable sequence when I click on the object. In my presentation I need to be flexible to the groups comments and questions.

  • RELEVANCY SCORE 2.97

    DB:2.97:Passing Presentation Variable In A Column Question 73


    Hi All,

    I am passing a presentation variable in a column . The variable is a number. i am using the level 0 of the flattened hierarchy for this. However, what i am looking for is passing the variable and showing the next column from the flattened hierarchy.

    Example :

    Variable value = 1
    it should display level 2 from the hierachy.

    if Variable Value = 2
    then it should display level 3.. so on and so forth.

    What is the way to do this.

    ANy help will be appreciated.

    thanks

    DB:2.97:Passing Presentation Variable In A Column Question 73

    Hi All,

    I am passing a presentation variable in a column . The variable is a number. i am using the level 0 of the flattened hierarchy for this. However, what i am looking for is passing the variable and showing the next column from the flattened hierarchy.

    Example :

    Variable value = 1
    it should display level 2 from the hierachy.

    if Variable Value = 2
    then it should display level 3.. so on and so forth.

    What is the way to do this.

    ANy help will be appreciated.

    thanks

  • RELEVANCY SCORE 2.96

    DB:2.96:Can Some One Tell Where In Obiee Presentation Variable Value Get Stored? ap


    Can some one tell where in OBIEE presentation variable value get stored?

    DB:2.96:Can Some One Tell Where In Obiee Presentation Variable Value Get Stored? ap

    Can some one tell where in OBIEE presentation variable value get stored?

  • RELEVANCY SCORE 2.96

    DB:2.96:Presentation Variable In Reports 9j


    If I understand correctly, Presentation Variables are setup in a Dashboard Prompt.
    Is this the only way to set it up ?

    Can I use presentation variable in any queries ? or just on the queries of that particular dashboard ?

    Txs. for any help.
    Antonio

    DB:2.96:Presentation Variable In Reports 9j

    Hi, To my knowledge it is not available. The session variables are the ones which is available across. But we cant create custom session variables

    -- Venky CRMIT

  • RELEVANCY SCORE 2.96

    DB:2.96:Re: Ask Help About Create Direct Database Request fx


    Hi katherine,

    Your connection pool should look like this "DEV_BI"."Connection Pool"
    Second thing is go to Administration/Manage privileages/Direct database privileage is there.
    If you want to use variables into your SQL query follow this link
    http://bintelligencegroup.wordpress.com/2010/08/26/how-to-use-the-presentation-variable-in-direct-database-request/

    Hope it helps you.

    By,
    KK

    DB:2.96:Re: Ask Help About Create Direct Database Request fx

    Thank you all the same.
    Then, are there any solution to this requirement?

  • RELEVANCY SCORE 2.95

    DB:2.95:Re: Checkbox In Presentation m3


    ..

    DB:2.95:Re: Checkbox In Presentation m3

    Hi Daniel,

    I solved that problem without using a method in the BPM Object but just using the one inside the Group, but now, for another topic, I would like to use something like you suggested.

    I would like to call a method of the external object from a method inside the group but I can't reach it. I can only access methods or attributes inside the group, so I'm not able to pass outside my zero-based int variable storing an index of a group's element on which I would like to do logic.

    Can you help me?

    Thank you in advance,
    Luca

  • RELEVANCY SCORE 2.95

    DB:2.95:Obi Dashboard Fill Presentation Variable With Nq_Session.Roles fa


    Hello,is there a way to fill a presentation variable on my dashboard with NQ_SESSION.ROLES?I have been using prompt to do the same but I dont need to prompt the user for his session roles. I just need to fill a presentation variable thatI then use in the data model to filter the data.Thanks for any help.

    DB:2.95:Obi Dashboard Fill Presentation Variable With Nq_Session.Roles fa

    Hi metalray,If your solution works, why not just hide the prompt? Set the custom CSS style for that section to display:none; The prompt will still initialize the presentation variable even if it's not visible to the user.JB

  • RELEVANCY SCORE 2.95

    DB:2.95:Filter Issue Using Presentation Variable 7j


    Hi all,
    I'm using a presentation variable in a column Fx in a pie chart. the same column i'm using in a drill down report as a filter(is prompted). When i'm clicking on a particular section of a pie chart it is not appending that filter.

    Please help if anybody knows .

    DB:2.95:Filter Issue Using Presentation Variable 7j

    Hi all,
    I'm using a presentation variable in a column Fx in a pie chart. the same column i'm using in a drill down report as a filter(is prompted). When i'm clicking on a particular section of a pie chart it is not appending that filter.

    Please help if anybody knows .

  • RELEVANCY SCORE 2.95

    DB:2.95:Request Presentation Variable Format Related Help dk


    Hi All,

    Thanks for visiting this thread.
    I need some help in formatting a date presentation variable.explaining my problem to my level best feel free to ask if you need more explanation.

    I want to know how to format/mask a Date presentation variable( having format YYYY-MM-DD HH:MM:SS) coming from a "calendar prompt" to YYYY-MM-DD.selected date in calendar prompt is automatically appending timestamp component of 00:00:00 i want to remove that.

    taken actions:
    In presentation layer column is already set as DATE TYPE.
    tried cast/evaluate/trunc but didn't succeeded.

    Thanks for your help

    -Niranjan K

    DB:2.95:Request Presentation Variable Format Related Help dk

    This is a bug: BUG 9280334 - CALENDAR DD/MM/YYYY PROMPT IN DASHBOARD RETURNING FORMAT YYYY-MM-DD HH:MI:SS
    there is a patch available on metalink

  • RELEVANCY SCORE 2.94

    DB:2.94:Re: Tax Program Help m3


    Is State Tax Due supposed to be one variable? You can't have spaces in variable names.

    DB:2.94:Re: Tax Program Help m3

    oooo okay thanks alot this really helped

  • RELEVANCY SCORE 2.93

    DB:2.93:Date And Presentation Variables zz


    Hi,
    can someone tell me how to manage date and presentation variables ?

    Informations:
    - my field, let say RECORD_CREATION_DATE, is of DATE type
    - BI maps it as TIMESTAMP after the db import step
    - I need to create a presentation variable, pass it to a report and calculate for each row the difference between this variable and the field RECORD_CREATION_DATE

    I hope someone will help me,
    Andrea

    DB:2.93:Date And Presentation Variables zz

    Hi Saichand.

    This is the syntax I used:

    TIMESTAMPDIFF(SQL_TSI_DAY,"- Data Apertura Chiamata"."Data Apertura Chiamata", date '@{DataChiamata}{2010-12-31}')

    When I type a date in the format 2011-01-31 directly in the the report promp form the report works, but if I select a date from the prompt calendar, the report doesn't work !
    When I select from the calendar the date put in the form is in the format 31/1/2011, if I logon with italian langauge, or 1/31/2011, if I logon with english language and the column formula in the report doesn't understand its format ...

    How can I do ?

    Thanks,
    Andrea

  • RELEVANCY SCORE 2.93

    DB:2.93:Capturing Url-Parameters In A Presentation Variable jc


    Hi,

    I'am using OBI 10.1.3.2 and was wondering if this is possible :
    - defined following reference within a narrative (example)
    http://server_name_or_ip_address/Analytics/Saw.dll?GoPath=/Shared/Test/
    SB2Action=NavigateP0=1P1=eqP2=Customers.RegionP3=2+Central+East

    - in test report SB2 would like to "capture" the value for Customers.Region in a presentation variable so that I can show its value in a narrative or text field in report SB2

    If presentation variables can not be used in such a context how can I solve this issue ?

    Help much appreciated.

    Erik Bammens

    DB:2.93:Capturing Url-Parameters In A Presentation Variable jc

    Hi,

    I'am using OBI 10.1.3.2 and was wondering if this is possible :
    - defined following reference within a narrative (example)
    http://server_name_or_ip_address/Analytics/Saw.dll?GoPath=/Shared/Test/
    SB2Action=NavigateP0=1P1=eqP2=Customers.RegionP3=2+Central+East

    - in test report SB2 would like to "capture" the value for Customers.Region in a presentation variable so that I can show its value in a narrative or text field in report SB2

    If presentation variables can not be used in such a context how can I solve this issue ?

    Help much appreciated.

    Erik Bammens

  • RELEVANCY SCORE 2.93

    DB:2.93:Re: Passing Dashboard Prompt Values fs


    Use substring function for the presentation variable.

  • RELEVANCY SCORE 2.93

    DB:2.93:Obiee 11.1.1.7.0 Presentation Variable Issue a8


    Hi Guys,I need to pass the value of a presentation variable to report through another dashboard prompt.Like, Suppose in main dashboard prompt I have a date column(Suppose Presentation variable name: DATE1) and using the DTAE1 variable I am calculating the 1st day of that month and storing into an another presentation variable called DATE2. And this DATE2 I want to use in my report to do other calculations. But here, value is not passing from DATE2 to report level. Can anyone please help me out.Thanks,Sudi

    DB:2.93:Obiee 11.1.1.7.0 Presentation Variable Issue a8

    Hi Guys,I need to pass the value of a presentation variable to report through another dashboard prompt.Like, Suppose in main dashboard prompt I have a date column(Suppose Presentation variable name: DATE1) and using the DTAE1 variable I am calculating the 1st day of that month and storing into an another presentation variable called DATE2. And this DATE2 I want to use in my report to do other calculations. But here, value is not passing from DATE2 to report level. Can anyone please help me out.Thanks,Sudi

  • RELEVANCY SCORE 2.91

    DB:2.91:Re: How To Sum A Variable? kj


    Can any one please give me some help?

    DB:2.91:Re: How To Sum A Variable? kj

    Hi

    I'm working on a report (RTF) that need to sum a complex calculated value within a group.
    The value is from a set of code like below:

    ---Code Start---
    var temp1
    If xmlfield1 = ''
    temp1 = xmlfiled2 * xmlfield3 / 100
    Else
    temp1 = xmlfield4
    End

    var temp2
    temp2 = (temp1 + xmlfield 5) * xmlfield6 / xmlfield 7
    ---Code End---

    And I need to sum the value of temp2 within a group with something like ?sum(current-group()/xdoxslt:get_variable($_XDOCTX,temp2))?
    As xdoxslt cannot working with xdofx, the statement above shows an error.

    The Result shall be
    Group1
    Group2
    Count(xmlfield1) Avg(xmlfield2) Sum(temp2) Avg(temp2)
    End Group2
    End Group1

    Can anyone guide me how to implement this (the code may be more complex)?

    Many thanks

    Edited by: 922945 on Mar 26, 2012 1:58 AM

  • RELEVANCY SCORE 2.91

    DB:2.91:How To Pass Presentation Variable Using Go Url?? ds


    Hi there,
    I've a report in dashboard that is filtered using a date prompt in the dashboard. I'm using GO URL to open another request which has the date filetr setup.
    How do I pass the presentation variable to that report using GO URL coz its giving me the following error:

    A date value was expected (received "day_kk"). here day_kk is my presentation variable
    Error Codes: QABPH2PO

    I'm using following for GO URL currently

    '(a href = http://server/analytics/saw.dll?GOpath=/shared/BI%20Reports/KK/KK%20Detail%20Tota)TOTAL TIME(/a)'

    Appreciate your help
    Thanks

    DB:2.91:How To Pass Presentation Variable Using Go Url?? ds

    I had gone through that. But htere also i couldn't get the info on how to pass the presentation variable values.

    thanks,
    karthick

  • RELEVANCY SCORE 2.90

    DB:2.90:Re: Unresolved Column When Using Presentation Variable In Answers Filter x8


    Put a default value after the presentation variable in your filter. If you don't put a default, then within Answers, the request doesn't have a value for the presentation variable. Click on the filter and add the default value there. Then it will work.

    Edited by: David_T on Oct 14, 2010 8:13 AM

    DB:2.90:Re: Unresolved Column When Using Presentation Variable In Answers Filter x8

    Thanks all for the help.
    By putting a default value for the presentation variable, it took care of the Answer's display issue.

  • RELEVANCY SCORE 2.89

    DB:2.89:Re: Actionlink Issue 19


    Hi,

    There wont be a problem if 'is prompted' and 'presentation variable' gets the same value always.
    But as in your case when is prompted is working and presentation variable is not assigning values at that point of time it shows No results. Since variable has not got any value assigned to pass.

    You need to create separate prompts to have different presentation variables assigned to a column.
    One info- In 11g we can pass multiple values through presentation variable.

    Create a separate page with the drill report and on the above of the drill report in the 'Edit dashboard' place the main report into a separate section. In the format section properties, in the Custom CSS Style Options (HTML Only) check the box and type 'display:none'. So this will hide the report section.

    Regards
    MuRam

    DB:2.89:Re: Actionlink Issue 19

    Hi,

    P3 is the destination column. In the sense, the column which is used to filter. Basically both the source and destination would be same for you.
    If you dont want to show the column in the report which is getting filtered then hide it.
    Let me know further.
    Refer below for the basic syntax
    http://obiee-bip.blogspot.in/2011/08/how-to-pass-filters-using-obiee-go-url.html

    Hope this helped/ answered.

    Regards
    MuRam

  • RELEVANCY SCORE 2.89

    DB:2.89:Re: Not Able To Pass Presentation Variable(On Timestamp Column) From One Report To Other 8k


    I understand that am not able to pass HH:mm:ss, are you asking me to modify the URL - xxxxx/analytics/saw.dll?DashboardPortalPath=%2Fshared%2FContact%20Analyzer%20for%20CMS%2F_portal%2FInternal%2FContact%20-%20Trace%20DashboardAction=Navigatecol1=CAST('01%2F01%2F1999%20HH%3Amm%3Ass'%20AS%20TIMESTAMP)val1=%22timestamp'@{segmentACDDateFrom}'%22col2=CAST('01%2F02%2F1999%20HH%3Amm%3Ass'%20AS%20TIMESTAMP)val2=%22timestamp'@{segmentACDDateTo}'I tried single quotes double quotes nothing worked...Thanks for your help Sreekanth

  • RELEVANCY SCORE 2.89

    DB:2.89:Re: Presentation Variable Syntax For Multiselect? ma


    Make sure you get the xml something like belowsawx:expr op="in" xsi:type="sawx:list" sawx:expr xsi:type="sawx:sqlExpression""Time"."T05 Per Name Year"/sawx:expr sawx:expr xsi:type="sawx:eval" default="A,B,C"PV/sawx:expr/sawx:exprStill logical query looks like ('A,B,C')If that works good if not raise your hands UP

    DB:2.89:Re: Presentation Variable Syntax For Multiselect? ma

    HI all,Any inputs will be highly appreciated. I am in need of using the presentation variable in logical query something like below.select a from tablea where c in (@PV)unionselect b from tableb where d in (@PV)unionselect c from tablec where e in (@PV)ThanksAjRe: Presentation variable syntax for multiselect?

  • RELEVANCY SCORE 2.89

    DB:2.89:Presentation Variable In Column Heading 3f


    Hi All,

    i have to use presentation variable in column heading. I can use it like @{presentation_variable} . I need to use @{presentation_variable}+15 in column header. what can i do for such a requirement. for example i have to display between 20 to 30 days in column header... 20 will be passed through presentation variable and i need to add 10 for displayng 30.

    thanks in advance for any help and any help will be appreciated..

    DB:2.89:Presentation Variable In Column Heading 3f

    Hi,

    I achieved that. By using 2 presentation variables instead of one....

  • RELEVANCY SCORE 2.89

    DB:2.89:Fail To Connec Lync 2013 Presentation za


    On Win7 ,now unable to connect presentation via Lync 2013 ,show error We couldn't connect to the presentation because of network issues.Please try again later . If use lync 2010 ,able to connect presentation
    .I re-installed lync 2013 and switch network ,same error . Please help me resolve this problem .Thanks !

    DB:2.89:Fail To Connec Lync 2013 Presentation za

    Hi,
    Would you please elaborate what kind of presentation failed with Lync client 2013?
    Assume it is Lync Server 2013 in your environment, if it is the case:
    If it is PPTs presentation issue, as Lync 2013 use WAC Server provide the function of PPT sharing, it will fail when something wrong with WAC Server, which Lync 2010 client doesn’t use WAC Server to share PPT, so Lync 2010 client will work normally.
    So please double check WAC Server.
    Best Regards,
    Eason Huang Eason Huang
    TechNet Community Support

  • RELEVANCY SCORE 2.88

    DB:2.88:Re: How To Set Default To In Dashboard Prompt From Presentation Variable Value pd


    If the prompt's scope is set to "dashboard," the value selected by the first prompt should be reflected by the prompt on the second dashboard page. Are both prompts using the same column? More details please...

    DB:2.88:Re: How To Set Default To In Dashboard Prompt From Presentation Variable Value pd

    Thank you David for this clue, it really helped me a lot.

    But Is there are any way to use the presentation variable with a date prompt and the operator is set to is between ?

  • RELEVANCY SCORE 2.88

    DB:2.88:Presentation Variable As Filter / Impact On Performance 7m


    Hi,

    let's say I have -
    1. A dashboard
    2. Dashboard has a prompt and a report
    3. Prompt is populating a presentation variable
    4. Report is filtered by that presentation variable

    The question is -
    During the execution of the SQL, when is the filter with the presentation variable applied to the query?

    In simple words -
    If the filter is like: Emp_Nbr is equal to/Is in @{Employee_Number}
    Does the filter become: (Emp_Nbr is equal to/Is in 50) and then run the query at the database
    Or does it run in the database for all the Emp_Nbr and then apply the presentation variable filter at the report level?

    Thanks for your help.

    DB:2.88:Presentation Variable As Filter / Impact On Performance 7m

    Hi,
    It applies filter based on the value that you select in the pormpt and filters data in the report.
    Will not run the whole report without any filter.
    You can check the query generated by OBIEE after you run the report in Settings-Administartor-Manage sessions

    This will not degrade performance as it applies filter.

    Regards,
    Srikanth

  • RELEVANCY SCORE 2.88

    DB:2.88:Okular Presentation Mode Shows Only Blank Grey Screen (Using Xmonad) s1



    I have a problem getting the presentation mode of Okular to work. When I select presentation mode, the screen is covered by a grey window with nothing in it. The only way to get rid of this window is by killing it from the window manager (i.e. the normal exit presentation mode shortcut (esc) doesnt work).

    I am using Xmonad as a window manager (using the KDEWM environment variable).

    It has been working before, but I dont know which update broke it.

    I am running KDE 4.5.2 and Xmonad 0.9.1.

    Any help would be greatly appreciated.

    Cheers,-Toke

    DB:2.88:Okular Presentation Mode Shows Only Blank Grey Screen (Using Xmonad) s1

    tohojo wrote:
    I havent found a way to make it stop doing that, but when the grey screen appears, pressing B twice seems to solve it, and make the normal presentation mode appear. (B is bound to Switch to blackscreen mode).

    This makes okular usable for presentations for me...

  • RELEVANCY SCORE 2.88

    DB:2.88:Re: Constrain Check Box Goes Away 1p


    Correct, Presentation variable does not work with Multiselect, i have NULL as a Value in DB for a blank column but my question remains same...

    If i select the SQL where NULL should not appear in DB prompt then constraints check box disappears...

    DB:2.88:Re: Constrain Check Box Goes Away 1p

    rahul,

    if you want to report NULL always irrespective of the selected values through prompts, create another identical filter and assign operator as "is null" and check "protect filter" option.
    i.e. col1 is Prompted
    OR col1 is null (protect filter option checked).

    -bifacts
    http://www.obinotes.com

  • RELEVANCY SCORE 2.88

    DB:2.88:Re: Hours In Page Prompt 3c


    Hi Gurus,

    Delclared presentation variable in the prompt set variable=pv_hour

    while declaring the variable in filter of hour column(column3)-
    syntax is
    click on hour(column3) + filter + select greater than condition and add variable + pres. variable + enterd pv_hour

    COLUMN3 is greater than @{ pv_hour}

    and i got below mentioned error details

    Error Details
    Error getting drill information: SELECT TABLE2.COLUMN3 saw_0, TABLE2.COLUMN2 saw_1 FROM yy WHERE (TABLE2.COLUMN3 pv_hour)
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "pv_hour". (HY000)

    hope you understand

    thanks

  • RELEVANCY SCORE 2.86

    DB:2.86:Can I Use Presentation Variable As Prompt Label ? fz


    Hello All,

    Can I use presentation variable as Prompt label ?

    Thanks, AK

    DB:2.86:Can I Use Presentation Variable As Prompt Label ? fz

    No You can't use presentation variable as Prompt Label it wont take the value.

    Mark if it is helpful.

    Thanks,
    Srikanth

  • RELEVANCY SCORE 2.86

    DB:2.86:Displaying A Presentation Variable In A Certain Format s8


    Hi Experts

    I have got presentation variable called WeekBetween, which is set by a slider (that is a dashboard prompt)

    When output the value of this variable (in a textbox @{WeekBetween}) it says *'1,53'*

    While the values are right, i would want this value to be formatted in the following way

    *1- 53*

    Please can someone help or suggest an accurate answer

    Kind Regards

    Hiten

    DB:2.86:Displaying A Presentation Variable In A Certain Format s8

    You can use the Replace function mentioned above only in column formula. If you do not want to use column formula to display this value, then you can opt for Javascript replace function. To implement it, you need to replace your presentation variable in text object with below code and ensure to check Contains HTML markup checbox.

    #60;div id=custDiv#62;@{WeekBetween}{Default Value}#60;/div#62;
    #60;script#62;
    var i = document.getElementById('custDiv').innerHTML;
    document.getElementById('custDiv').innerHTML= i.replace(","," - ");
    #60;/script#62;

    Let me know if this works for you.

  • RELEVANCY SCORE 2.85

    DB:2.85:Date Prompts From One Date Column 3x


    Hi Gurus,
    I am trying to get Date Prompts from one Date Column. This is the approach i followed from previous post.

    Re: how to get date prompts from one date column

    My Approach
    1) In the report I set filter on Date column with presentation variable as startdate with some default date and in the fx window i applied
    CASE WHEN 1=0 THEN table.Date ELSE table.Date END
    2) I repeated the same thing by getting same date column with Presentation Variable as Enddate with some default date and in the fx i applied
    CASE WHEN 1=1 THEN table.Date ELSE table.Date END
    3) In the Dashboard prompt i got the same date column twice by applying same formulas in fx, default to - server variable - sysdate and setting Set variable - presentation variable - startdate and same thing with Enddate.

    The report is working fine but the report is not pulling all the records. I mean to say i have data from 12:04:36 am but report is pulling from 12:37:53 am. So i am missing some records. I dont know where i am doing mistake.

    Could someone please help me out

    Thank You

    Edited by: 792011 on Sep 14, 2011 11:00 AM

    DB:2.85:Date Prompts From One Date Column 3x

    What version of OBIEE are you using? Is the content in the variable the same data type and format as the prompt column?

  • RELEVANCY SCORE 2.84

    DB:2.84:Unable To Set Presentation Variable To Prompt Default. 9c


    i am tying to apply prompt default value as some presentation variable.

    as i want to set depending on the value selected by Same prompt.please help me.

    or else help me to write sql statement with presentation variable(of other prompt) to set default.

    Edited by: user12078402 on Oct 28, 2009 5:21 PM

    DB:2.84:Unable To Set Presentation Variable To Prompt Default. 9c

    The reason I made my suggestion is that you can't use presentation variables in the "Default" section. As I said, you can have a specific value, a SQL expression, a session or repository variable, but unfortunately, not a PV. Sorry.

  • RELEVANCY SCORE 2.84

    DB:2.84:Help On Presentation Variable And Drill Down kd


    Hi, help me to solve this problem . . . I've a hierarchy based on the dates( years half four months months ) and i've defined many prompt that help me to drill down in the hierarchy every single prompt set a presentation variable the problem is how update the value of the prompt(and of the presentation variables) when i drill down directly from the results table .
    So, if i click on a value in the table, for example year, in the prompt, and in the presentation variable, must be placed the year clicked previous (in the table)..

    help me please!!!!! thanks a lot

    DB:2.84:Help On Presentation Variable And Drill Down kd

    Hi, help me to solve this problem . . . I've a hierarchy based on the dates( years half four months months ) and i've defined many prompt that help me to drill down in the hierarchy every single prompt set a presentation variable the problem is how update the value of the prompt(and of the presentation variables) when i drill down directly from the results table .
    So, if i click on a value in the table, for example year, in the prompt, and in the presentation variable, must be placed the year clicked previous (in the table)..

    help me please!!!!! thanks a lot

  • RELEVANCY SCORE 2.84

    DB:2.84:Re: Problem With Variable 9f


    SP2-0552
    and information variable connected "zmn" in not declare or something else

    thank you very much for help

    DB:2.84:Re: Problem With Variable 9f

    Jesus, is it really that hard to read?

    AgainAgain: Please show the output of a real session where you run this anonymous block!!!

    Apologies for the exclamation marks. ;)

  • RELEVANCY SCORE 2.84

    DB:2.84:Presentation Thumbnails? s7


    Help I need to print thumbnails of my presentation

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: Po Rtf Template Variable Row Height xd


    anyone help please !!

    Thanks

    DB:2.83:Re: Po Rtf Template Variable Row Height xd

    Use a PDF template, or use bitmapped reporting. Otherwise you need a third-party product.

    Kurz

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: How To Display Presentation Variable In The Title View 9d


    I donot have the date column in my request and I cannot add it in request and hide it....

    hence I followed this link..to achieve the solution..It worked..
    I used text object of Dashboard to achieve the result...

    http://bischool.wordpress.com/2009/05/05/presentation-variable-values-in-report-titles-or-using-presentation-variable-in-dashboard-text-object-and-narrative-view-directly/

    But displaying the presentation variable in timestamp format ... I need it to be displayed in Date like 04/24/2011 and not like above said..

    Thanks in advance...

    DB:2.83:Re: How To Display Presentation Variable In The Title View 9d

    this is disabling my calendar option..we need calendar control prompt.

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: Presentation Variable Problem pc


    My problem is this filters which are based on these presentation variables are repeated a number of times.what do you mean by this? and where you observed?

    need an example from your side..

    DB:2.83:Re: Presentation Variable Problem pc

    Actually there was no problem. I misunderstood the query.

    Consider this is my filter set.

    [
    A or
    B or
    C
    ]
    And
    [
    D is between From_Date and To_Date
    E is between From_Date and To_Date
    F is between From_Date and To_Date
    ]

    The actual query was something similar to this

    where (D = From_Date or E=From_Date or F =From_Date) and (D=From_Date or E=From_Date or F=From_Date)
    .
    .
    .
    .
    etc

    The problem was I thought the same condition is repeated 8 times. But it was not.
    The query generated by the OBIEE was correct

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: Displaying Presentation Variable Name In Dashboard Text dj


    Hi Mark,I have observed that OBIEE could not interpret the variable if a space is placed between @ and variable name.So, in your example, if you add string as @ {My_PV}{Horse} instead of @{My_PV}{Horse}, the same would be displayed on the dashpage (with a space in between).Hope this helps you.-Pavan Kumar.

  • RELEVANCY SCORE 2.83

    DB:2.83:Presentation Variable With Default Used In Filter Sql Expression zp


    Hi,
    I'm trying to use a default value for a presentation variable used as part of a sql expression in a filter and could use some assistance on why obiee is choking on the syntax.

    I have a prompted report that has a prompt on month name (setting presentation variable - pres_month_name). The prompted value is used in a filter as a sql expression. The sql expression is a CASE on the presentation variable and converting it into a number based on business rules.

    In the sql expression, I'm giving the presentation variable a default value of a repository variable - rep_default_month_name. The repository variable is correct and does, based on business rules, return a proper default month name.

    Now, if I hard code the default value, there is no problem. Here's a sample of the filter:
    Month Number less than or equal to *CASE '{pres_month_name}{OCT}' WHEN 'NOV' THEN 10 WHEN... END*

    notice the presentation variable is in single quotes since it's a character field. Once again this works fine, but I don't want to hard code the default value, I want it based on the repository variable, so:

    Month Number less than or equal to *CASE '{pres_month_name}{ValueOf(rep_default_month_name)}' WHEN 'NOV' THEN 10 WHEN... END*

    By having this syntax for the presentation variable's default, I'm getting a message of incorrect values in a filter.

    This report is not only used on a dashboard, but used as part of a briefing book as well. Anytime a briefing book is updated, the presentation variable's default is used, since obviously the presentation is not available in a briefing book, and I don't want to use a hard coded value.

    I could duplicate the report and adjust the sql to not use the presentation variable, but always use the repository variable that returns a default month, but I'd be duplicating efforts and I'd have to do this on many requests.

    Thanks for the help!

    DB:2.83:Presentation Variable With Default Used In Filter Sql Expression zp

    David,

    Thanks for the suggestion, trying one of the other syntax worked:

    ...CASE '{pres month name}{@{biServer.variables['rep default month name'] }}

    I already had the document you directed me to printed at my desk. The strange thing is in the same request, I have another filter based on the prompted year and defaulting to a repository variable, but it's not in a sql expression, it's a variable expression. I was using the same type of syntax (no problems with it) as in the filter causing me problems. In the documentation, it has using VALUEOF( ) for the repository values in Filters, not @biServer.variables...
    oh well, it works.

    Thanks!

  • RELEVANCY SCORE 2.83

    DB:2.83:How To Use Presentation Variable In Rpd? fs


    I need to use Presentation variable in RPD column.

    Can someone help me out for that?

    Thankx in advance.

    Regards,
    Sudi

    DB:2.83:How To Use Presentation Variable In Rpd? fs

    997800 wrote:
    I need to use Presentation variable in RPD column.

    Can someone help me out for that?

    Thankx in advance.

    Regards,
    SudiHello Sudi,

    If I understand you correctly, you are looking to pass a value into the RPD logical column and then get the data as
    "Value" selected by the user on the dashboard prompt.

    If this is what you are looking for. There are two ways of doing it.

    1) If the user will have access to the Advanced tab of the report in Answers, then he can set the variable in the Prefix section

    Example: SET VARIABLE SessionVariable = '@{PresentationVariable}{DefaultValue}';

    From above, SessionVariable must be created in RPD.
    On the dashboard column prompt "PresentationVariable" type.

    Use the SessionVariable must be used in the logical column formula in the logical layer.

    2) If the user will not have access to Advanced tab of the report, then we can do this using "Request Variable".

    When the Dashboard prompt column type is set as Request Variable, the value can be passed into the RPD logical layer formula where the SessionVariable is used. The value will be same as the value selected by the user on the dashboard prompt which is a Request Variable.

    Please mark if helps.

    Thanks,
    G. SK

  • RELEVANCY SCORE 2.83

    DB:2.83:Reg:Change Presentation Value Depending On The Dashboard Page 1p


    hi,

    is there any way to change the presentation variable value(using only one presentation variable) in presentation services depending on the dashboard page name.

    thanks

    DB:2.83:Reg:Change Presentation Value Depending On The Dashboard Page 1p

    Presentation Variable will hold the value whatever selected on the Dashboard prompt.

    For Example:

    IDashboard prompt is on Region and the PV is given as vRegion.

    On the report: The Region filter must be something like this:

    Region is equal to / is in @{vRegion}

    So if Region Northwest is selected on the Dashboard and ran the report, you will see only that region since the filter will be applied on the report something like this:

    Region is equal to / is in Northwest

    Hope you understand until this part. Now, please open the report and check this filer and see if the filter is Protected.

    Hope this helps.

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: Presentation Prompt Variable Not Working xp


    at least can you see the value Year-1? Can you confirm this?

    DB:2.83:Re: Presentation Prompt Variable Not Working xp

    Thank so much for your time. I found out a solution using AGO, and filtering against the Variable Prompt.

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: Dashboard Prompt - Link Or Image - Presentation Variable -Dynamically cs


    Also make sure that the detail sales report is filtered on the appropriate column to receive the value of the prompt.

    DB:2.83:Re: Dashboard Prompt - Link Or Image - Presentation Variable -Dynamically cs

    If you set up the hierarchy right, you don't have to create each prompt in separate files. I use a Region prompt and a Branch prompt. Because they have a drill down hierarchy, I check the "constrain" checkbox on the branch prompt and when I select a region in the region prompt, the branch prompt gets constrained to show only the branches in the region before clicking on the "Go" button.

    I guess I was answering your specific question (how to call a presentation variable from one prompt and use it in another), but it is not always necessary to do.