Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Marisa Escobar
    Report Parameters in OTBI Reports
    Topic posted April 26, 2018 by Marisa EscobarBlue Ribbon: 750+ Points, tagged OBIEE Answers, OTBI, Reports 
    1306 Views, 6 Comments
    Title:
    Report Parameters in OTBI Reports
    Summary:
    I would like to be able to have the report parameters visible in OTBI reports
    Content:

    Hi Folks-

    Is there a way to have the report parameters included in OTBI reports?

    Attaching screenshot for what I am driving at.

    Thank you!

     -Marisa

     

     

    Image:

    Comment

     

    • Alexey Shtrakhov

      Hi Marisa,

      Without knowing the background of your needs...why don't you just create a dashboard where user can filter that data based on prompts and then pull more ready data to excel for filtering and so on? You could try to use Smartview for these types Analysis as well... Then on that smartview Excel you could create needed template.

      Or do you send those reports to some other people without having access to application?
      Another chance would be to create BIP report with Excel template (can be macro enabled). This would allow you to do very complicated scenarious where you pull data for users to a predefined excel template (can be macro enabled) and user can continue working on that data using some functionality you developed on template.

      Alexey

    • Marisa Escobar

      Hi Alexey-

      First, thank you for replying to my post!

      I am just looking to find out if the parameters that were used to run the report can be included in the output so the user can see what parameters were used to create the report.

      In the example I posted an image of, I would like to be able to say that I selected

      Bank Account: xxxx9456

      Created By: All Users

      Of course that would change as each users uses different parameters to run the report.

      I think this is useful information for a report, and the export output, to have regardless of where it is created. Same as the run date/time information, which is an option I can include in the Title area.

      Hoping that makes my background needs more clear.

      Thanks, again!

       

       -Marisa

       

      • Alexey Shtrakhov

        Oh, in that case just add Filters view to your report. See image provided.
        This view will list all the parameters used to run the report.

        Alexey

    • Marisa Escobar

      Hi Alexey.

      I added a filter view, but not sure I am doing it correctly. My report in this case has prompts where the user has two drop-down lists to select the bank accounts they want included in the report and choose the Created By field.

      Is it possible to have a filter view and still use prompts? When I add the filter, the parameters do appear at the bottom, however, they are locked to what I used as a filter. In this case I selected every option. I can't find a way for my prompts to still work and those prompt parameters appear in the report output.

       -Marisa

    • Alexey Shtrakhov

      Hi Marisa,

      I think it is not possible to export an analysis to an excel with interactive filters / prompts. But maybe somebody in the BI community can give their final verdict.

      I think those 2 proposed workarounds could work at least.
      1) Smart View template
      2) BIP based excel template with some macros...

      Alexey

    • Murali Gangidi

      Keep your prompts as Presentation Variables (Prompts --> Options --> Set a Variable --> Presentation Variable)  and add them in the Results Output or Title.

      In the Prompts, give the Parameter  Name say  as P_NAME and in the results output Title Block give Name : @{P_NAME}.

      If you don't give any parameters while running the report , then the output will be coming as Name : @{P_NAME}, but if you run the report with the name parameter  say *** then output will be coming as Name: ***