That XML doesn't look right to me. Either way, you should just be able to nest your groups to achieve what you want. I know I have done something similar in the past however i'm out of the office so can't get you the exact syntax.

Glad to be of help.

Niclas, Have a look at these links. Never name it.: XML Publisher -- Can you limit returned rows in a loop ? https://blogs.oracle.com/xmlpublisher/wildcard-filtering-continued --> Applying a filter to your grouping based on one of the fields within that group Hopefully they help. If you want to take a look at variables,…

Hi, I'm a touch confused. When you start looping through entity and you begin your "for each phones" loop (ie entity/phones), this shouldn't include the director as the director information is under entity/director/phones. What am I missing? Either way, could there be any way you can use wildcard filtering to filter out…

Are you using a template of any sort? We use HTML anchors in our reporting which I can confirm works in HTML and Excel outputs (Unsure about PDF). Try this link.

I've never used a seeded data model but would something like what's described in the following work where you download the model to a zip file and manually create the join between the datasets? https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=500139775040682&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id……

Is there any sort of key that joins this data together or are they completely separate? If there is a common field in both datasets you can join them in your datamodel which will allow you to use data from both datasets in the same loop.

Supplementary Details: - It seems to be only impacting where the physical db is MS-SQL. - Turning off cache on each physical table in the subject area "fixes" the issue.

You don't need to be nice to me Christian haha. I am well aware that the problems we are facing are with our design and not the product itself. As for the virus, I hope you and your family are staying safe. I have family friends who live in Cologne, Germany and believe me, I am taking it very seriously.l the All the best

Ok that makes sense. I ended up turning cache off on all the tables this report uses and now, without cache, it runs in 7 seconds vs 20. Go figure!

I have also realised that as soon as my query introduces any sort of complexity, using AGO for aggregation etc, cache is created but not utilised. Can anyone confirm whether certain functionality is deliberately not put into cache?

I have tested other subject areas using combinations of calculated columns and non-calculated columns. Every test results in the following: If the column used in the filter does NOT exist in the criteria, cache hit will not occur. The column can be excluded from the analysis and it will result in a cache hit. Would there…

I understand what you're saying but it seems like something isn't working as expected based on the troubleshooting I've done. Next step is to try the same experiment using a different subject area. If that works fine, then I know it's definitely related to the design and not a big with the product. Thanks Joel.

Sorry for the wall of text here guys but I think I have discovered something. It seems that cache will only be used when the column that is being used in the filter is also in the select statement. Is this an expected result?

The following query generates a cache entry: SELECT "Retail Snapshot"."Lending Activity"."Activity" FROM "Retail Snapshot" Running this query straight after generates a separate cache entry SELECT "Retail Snapshot"."Lending Activity"."Activity" FROM "Retail Snapshot" WHERE "Retail Snapshot"."Geography"."Unit Code" = '9019'…

The first cache entry is me running the logical query with no filter. I ran that same query another two times to prove that cache was created and used when the query is identical. The second cache entry was me running the logical query with a filter of "where unit = 9019". As you can see, it creates a new cache entry even…

@Joel Acha, so I pulled out the logical query of one of the analyses, ran it via the "issue SQL" section and then ran the dashboard. No cache hit. I'm so confused!

Thanks Christian for your reply. I know everything you've said is spot on. This report has been the bane of my existence for many years now. Designed by the business with the developers pushing back. Unfortunately, politics got in the way and... you know how it goes. Suffice to say, i'm trying to pick up the pieces many…

Thanks Joel. I'll give that a try.

Just some supplemental details for this... 1. Our dashboard has a prompt containing approx 10 values. When a user logs in, using row value security, they may only have access to 1 or 2 of these values. However Admins and power users can see all rows. 2. All physical tables have cache turned on and no expiry set. 3. Cache…