nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OTBI Analysis showing Filter values in Excel Output

GauravGupta39

Summary

OTBI Analysis excel output showing filter values along with data and scheduler ran twice, while it was set to run once every week

Content

Hello Everyone,

Our OTBI analysis report is showing the filter values I have setup while creating the analysis at the very end of report. Image of filter values is attached with this post as filter_val_img

I have looked into Criteria, Results and Advance section of OTBI analysis, but was not able to find anything that control display of filters on generated report.

Also, is there a way I can check the analysis run, as above mentioned OTBI analysis ran twice, while the agent that is attached to this analysis was set to run once every week on Friday. But, our end users got 2 reports in 1 minute interval, and second report had filter values mentioned.

I am providing screen shot of scheduler agent with this post.

Please let me know if you need any additional detail to help me figure out this issue.

Any help is appreciated.

Thank you and Regards,

Gaurav Gupta

Find more posts tagged with

SQL

BI Publisher

OTBI

Comments

Ellen Manthei

Can you share the catalog file of the analysis?

Thank you,

Ellen

GauravGupta39

Hello Ellen,

Thank you for your reply. I am attaching catalog files of the analysis.

Please let me know if you need any other information from my side.

Thank you and Regards,

Gaurav Gupta

Ellen Manthei

From what I can see in this specific analysis and agent, it doesn't look like anything within it is causing the results you are seeing. Are you sure there isn't a second analysis and/or agent? If this happens again, I would enter an SR.

Sorry, I can't be of more help.

Ellen

SantoshKumarBhairi

Hi Gaurav,

For filters in exported results - try this:

You would have included 'Filters' in your results-view. Scroll-down and you will see them in a section. When you export, filter-set will also be included. You can remove it from the results-view.

For agents issue - check Administration / Manage Agent Sessions exactly at its execution time. If you see more than one active agent for the same report, then grab its name and search it in the catalog.

thanks,

Santosh