A way which may break with any minor OBIEE update, if you want a reliable solution use BIP,UTL_FILE,APEX... and many more options better then OBIEE

Avinash Pentyala wrote:SonPat99 The user ants append the date to export file names(Analysis & Dashboards) I would tell this user that he needs to alter the filename himself after download as it is impossible to do so with OBIEE and definitely not worth hacking your system for

Yes it depends on the exact requirement. At least the OP now has multiple solutions to choose from :-)

Yes that is correct, I was thinking too complicated :/

If you want to count the unique conbinations then you should do something like count(distinct concat(Concat("ID",'~'),"Decision ID")) The ~ is use as a separator to make sure that for instance 10 and 11 are not counted as the same as 101 and 1 EDIT: If the ID's are numbers then use Cast as Char to convert them to chars

Count(Distinct ) will do that. Either set it as aggregation rule or use it in the formula depending on your exact requirement

You're not getting links to sub optimal solutions from Christian my friend ;-)

Or rather: Don't try to mail big datadumps at all

Fix: Don't try to mail large datadumps from OBIEE, it's an analysis tool not a datadump utility

What exactly are you trying to achieve? It seems like a cumbersome manner to pivot your results. Please provide a detailed example of the expected results, and how you plan to use those results (why is this needed)

At the very least you should remove authenticated-role from the BI Consumer Role to restrict login access to only users with BI Roles instead of anyone who has access to the LDAP.

Dimitris Karydis wrote:I want it to be hidden because for the requested report I had to split in 2 different tables and put them side by side and I don't want the attribute to be shown 2 times. I want the side by side tables to look like 1 even if they are not. Why can't you do it in one view? If you need to show measures…

Not out-of-the-box afaik. If you want pixel perfect layout for printing you might want to consider using Custom Printing layouts / BI Publisher. See Creating Custom Print Layouts in OBIEE 11.1.1.7.0

What does your pivot design look like? You could create a table view instead, creating 'pivotted' columns or buckets as i like to call them using a CASE WHEN construct. This will only be a realistic approach if you have a fixed and relatively small number of buckets that you want to include however. EDIT: And why is the…

How to display correct subpage based on selection? Well, By just selecting (clicking on) the sub page that you want to see. If only a single section should be displayed at one time, then why make it complex by putting them on the same page?

Apparently this may fix the issue: https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=10ctdnsnd0_4&_afrLoop=553761404048053#FIX Somebody in my network told systems without this patch failed but not the 12.2.1.3 with this patch applied. Have no experience with this patch myself though

Yep, here also today

Why don't you just keep it simple and place each view on a separate dashboard (sub) page? Seems like a lot of (complex) effort for a minor requirement? If you really think you need the prompt selector way, Is this what you are looking for?:…

It seem like Robert knows what you are talking about but this question is very unclear and you are luck y to get any help at all with a question dropped like this. Please study

True, re-implement may be cleaner, depending on what exactly you need to migrate. OP is talking about upgrade however, so I linked to the Rittman post to help him realize what that will mean for his situation.