Forum Stats

  • 3,874,263 Users
  • 2,266,716 Discussions
  • 7,911,794 Comments

Discussions

Prompt values not getting picked in navigation report

I have a request A in a report from which i have setup navigation to another report on the column "Project Name". The target report has the filter "Project Name is prompted", and the project name gets picked up from the source report on navigation.

However, i have a report B which combines 2 similar requests. One request has the field "Project Name" in it, while the other request just has a string in place of "Project Name" because i cant use the "Project Name" field in my second request.

Now, in report B, i have defined exactly the same navigation in the Result Columns on the project name, however the project name does not get picked up automatically when navigating from report B.

Would be great if someone can help.

PS - both reports A and B have only one field in the prompt, which is not the project name.
Tagged:
«1

Answers

  • JasonBaer
    JasonBaer Member Posts: 130
    Hi Jimit,

    By any chance are these reports ending up on dashboards? You can create a dashboard prompt for Project Name to initialize a presentation variable. Then use that presentation variable in the filter of all your reports.

    JB
  • Jimit
    Jimit Member Posts: 130
    Hi,

    Yes I have these reports on dashboards. I have implemented the workaround you mentioned, however I am also looking to find out why I am facing the problem I am facing.

    Any ideas?
  • Jimit
    Jimit Member Posts: 130
    Guys.

    I had to remove the workaround because i cannot place the project name field in the prompts. We do not have to allow selection by project name. We just have to allow selection of departments so that all projects in the department show up.

    Would appreciate a lot if someone can throw in a couple of more ideas.
  • JasonBaer
    JasonBaer Member Posts: 130
    Report B doesn't pick up the project name because as you mentioned yourself, it doesn't include Project Name it only includes a hardcoded string. When your navigating from a host report to a target report you need to use the same columns from the presentation layer if you want the values to be passed. If you don't use the same column there's no way for OBIEE to tie the two together... that's where the presentation variable comes in.

    The solution I mentioned works. There's only one way to create a presentation variable, and that's by using a prompt. If you don't want the prompt to appear on the page because it's not a requirement, just hide it. Format the section that it's in and add display: none; to the CSS custom style window. It only needs to be on the page with the host report (visible or not) so that the variable is created. Set the columns on the target report to be equal to the presentation variable and you're done.

    JB
  • Jimit
    Jimit Member Posts: 130
    Hi Jason,

    Thank you so much, thats a wonderful tip. I am almost ready with what you suggested me to do, however i am facing some issues. I am getting No Results in my target report. Apparantly its not picking up the project name filter correctly. Can you help? I'll show you what i have done.

    1) Created a project name prompt as show in the below image:
    https://docs.google.com/file/d/0BzdimOKCEF76UXVNYlVwMHN6RVk/edit?usp=sharing

    2) Added a filter in my target report as follows:
    https://docs.google.com/file/d/0BzdimOKCEF76VWVsaGo2b0NZQXc/edit?usp=sharing

    3) Added conditions in my target report as follows:
    https://docs.google.com/file/d/0BzdimOKCEF76WU5HWmhnWWdUM2c/edit?usp=sharing.

    The result is empty as shown in the below image:
    https://docs.google.com/file/d/0BzdimOKCEF76cjBkck5SM1poWkk/edit?usp=sharing

    I am sure you will be able to point out my mistake in seconds! Thanks in advance for your help!


    Jimit
  • JasonBaer
    JasonBaer Member Posts: 130
    The filter on the target report is incorrect. You have...
    Project Name is equal to /is in projectname

    This filter has 'projectname' as a string. But you want to reference the presentation variable you set up, like this..
    Project Name is equal to /is in '@{projectname}'
  • Jimit
    Jimit Member Posts: 130
    Hi Jason,

    Followed your recommendations but still getting error.

    1) Added a filter like this
    https://docs.google.com/file/d/0BzdimOKCEF76czJRUW5XTjVxTWM/edit?usp=sharing

    2) Still getting no results
    https://docs.google.com/file/d/0BzdimOKCEF76Yzl5OHVOZGtOQmc/edit?usp=sharing

    3) Converted filter to SQL like this:
    https://docs.google.com/file/d/0BzdimOKCEF76YktiRWdnN1ZJZ0U/edit?usp=sharing

    4) Still getting no results
    https://docs.google.com/file/d/0BzdimOKCEF76TkJkcEcySHdjM3c/edit?usp=sharing

    I'm quite a novice. Do excuse my ignorance! Am i missing something?
  • JasonBaer
    JasonBaer Member Posts: 130
    How are you referencing the presentation variable? This site walks through the basic steps...
    http://obiee101.blogspot.com/2009/03/obiee-referencing-presentation.html

    Are you getting an error? Or just no results?
  • Jimit
    Jimit Member Posts: 130
    Hi ,

    The method shown on blogspot was the one i was using earlier.

    After we had a chat i followed what you suggested.

    PS - i am just getting no results. No error is thrown up.
  • Jimit
    Jimit Member Posts: 130
    Is it possible that the value for projectname is not getting assigned to the variable in my host report?
This discussion has been closed.