I was able to identify the issue. I had to change the localedefinitions,xml config file and change the date format there.

Thank you.. Let me try modifying them.. I really appreciate your inputs on this!

@Gianni Ceresa I was able to modify the iframe but I get a different error now. "Refused to display 'URL' in a frame because an ancestor violates the following Content Security Policy directive: "frame-ancestors 'self'". I have enabled the CSP policy. <ContentSecurityPolicy> <PolicyDirectives> <Directive>…

Sorry for the delayed response.. I guess Size of the iframe should be defaulted to size of the dashboard page. The existing JS code is from legacy system, so I'm not really sure about the actuals.

Thanks @Gianni Ceresa for your analysis. Is there any sample jQuery code that I can use since I'm not sure of how it works with OBIEE? It would be great if you can help me with that. Thanks, Sai

You are right.. that was the first step I did. <ServerInstance> <Security> <ContentSecurityPolicy> <PolicyDirectives> <Directive> <Name>frame-src</Name> <Value>*</Value></Directive> <Directive><Name>img-src</Name> <Value>*</Value> </Directive> </PolicyDirectives> </ContentSecurityPolicy>

When I add the mentioned code on to the dashboard text section and run it. A blank screen gets displayed. When I run through the debugger on the browser tools. I get something like this "Blocked loading mixed active content".

Thank you!! Will check after changing the log_level to 5, coz.. 2 wasn't giving me info abt the logs.

Did you mean.. aggregate based on dimensions?? If so, please refer the below article.. https://gerardnico.com/wiki/dat/obiee/obis/aggregation_based_on_dimension

Do we have any other alternate solution for capturing this? Thanks for your valuable inputs!!

Thanks Christian! But we are still on 11.1.1.7.14 .. Usage Tracking is already in use.. Will try to check on table you have mentioned..

Do you have this table data in Database or in Excel? In any case, you have to build your RPD... and Create chart view.. Not sure of the exact problem you are mentioning... Please elaborate on the exact issue..

Solution: Create a Copy of Summary Report and save it. Use filter based on another request even on the Detail Report and point to Copy of Summary Report. This will eliminate circular reference.

Summary Report: Has Quantity aggregated to Quarter.. where I'm using a filter which picks set of item numbers from another report request (Conditional Report). When drill-down on Quarter it will navigate to Detail Report. Conditional Report: Item numbers relevant to different fact (not from the Summary report measure)