Hi Gianni, thanks for taking the time to respond, I'm talking about OBIEE Analyses that use Answers Subject areas: Financials - AP Transactions Procurement & Spend - Invoice Lines These are the main culprits of poor performance. All I'm looking for really is for detail of what exactly happens when an extra global currency…

Hi Aiswara, the link you left is the link I provided to the developers to show that the change DOES in fact add volume to WH tables. I do not have access to nor did I make the change to BIACM, and will that show me that the change affects the WH tables? I'm just looking for confirmation of how this change works, so I can…

OK I've fixed this now by simply adding a filter for 'Is Prompted' OR 'IS NULL'. Sometimes you get so wrapped up in one idea you can't see the wood for the trees. I'm still intrigued as to why this (Thoroughly messy I know) formula doesn't operate?

Hi Joel. Visualisation has been considered as a potential future solution but the sheer volume of data and the lack of trust in the end users is preventing the business from wanting to move forward with it at this point. Thanks for your help though.

Perfect, thank you!

Hi, Standard functionality doesn't allow you to conditionally hide a Dashboard Page or Subpage. You can, however conditionally hide a dashboard section. Would it work for you if your dashboard section contained a link to a hidden dashboard page/Subpage, so the section would show when your criteria is met? Hidden dashboards…

Hi Thomas, What would you suggest is "The proper Tool". I see this answer a lot on this forum though I've not seen anyone give recommendation? Serious question, not goading just struggling to articulate without coming across as facetious. Cheers,

Hi there, Apologies this wasn't successful though I thought at least the logic may help. Do you see what I was trying to do? If you can find a Timestamp for the start date plus the number of months of service then you have the timestamp to look for the TIMSTAMPDIFF for the number of days between that timestamp and today.…

Couldn't agree more. I know users who reconcile GL at item level just incase an item has been booked against the wrong code, and they do this EVERY MONTH. Trying to explain exception reporting is doing the proverbial into the wind. I'll get there with them in the end, fingers crossed. It could be the browser though I had a…

Thanks Robert, I have done that elsewhere actually and it would work quite well here - It's a trial balance Pivot so I can subtotal on the substring which would please the users enough to forget about the table resetting If anyone has the Cause or fix though it would be appreciated. Cheers,