I assumed you wanted a presentation variable, the; - @{ValueFromHere}{-99999999} syntax is a presentation variable called ValueFromHere with a default value of -99999999

Sure, not sure what language that is, but in English; - "Folder"."Whatever" between @{ValueFromHere}{-99999999} and @{ValueToHere}{9999999999} or ("Folder"."Whatever" >= @{ValueFromHere}{-99999999} and "Folder"."Whatever" <= @{ValueToHere}{9999999999})

Let he who is without material mis-statement cast the first stone...

I would never be so bold as to say 'The' only possible workaround, 'time does make fools of us all' ;-)

One possible workaround is to create your grand totals using a union query, then they are just normal rows and you can do whatever you can do to normal rows....

Sorry, not had the need to try it for myself, I would follow @Gianni's advice of digest, contemplate, adapt - good advice for life in general perhaps...

Are you looking for this -> OBIEE Print Dashboard Page PDF without Prompts

In terms of other options you could also use the function 'filter' to achieve similar ends, or sum by in conjunction with case statement.

Hi, just duplicate your measure and drag it to the Year level of your time hierarchy. This will make that version of your measure invariant for anything lower than year in your reports. You can then use this as the basis of your YAGO measure.

Hi, simple test re: Gianni's comment - simplify the analysis to 10 core columns, run it. Is the runtime massively faster - if yes then you know that the problem comes because of the scale of the data that must be presented in the web. Stand back - think would you be better doing this kind of data dump via BI Publisher?

Have you seen; - Information about DXE Execution in OBIEE Sessions (Doc ID 1527672.1) https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=525649128479542&id=1527672.1&_afrWindowMode=0…

Also are you comparing like with like - is your faster DB sql running at the same time from the same client?

Have a look at; - OBIEE 11g Bi Scheduler Gives Error: "[Nqserror: 75005] Failed To Send Auth Command. 5.7.3 Authentication unsuccessful"(Doc ID 1225454.1) https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1225454_1.html

Do you have back ups to refer to?

Note 2: I have been 'on a rescue mission' in a number of organisations that have tried to implement OBIEE purely on database views / opaque views. To use my favourite metaphor this is like buying a screwdriver and using it to hammer nails. It is sub-optimal. It has no reusability, one view generally equals one query. It…

And; - https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bimad/mad/mad.html

Have a look at these - https://www.peakindicators.com/blog-category/mobile

Yuk! I don't see the point of the concat as concat joins two fields and the '.' seems largely pointless and only serves to unnecessarily complicate (sic) the code without adding value. I would read it as; - (IF Dim_Users.User_id is not null then 'Restricted' ELSE IF DIM_CUSTOMERS.CUSTOMER_ID is not null then 'Limited' ELSE…

Did you recently move your catalogue from another environment? Was it a binary transfer? (not text)

Convert a copy of your rpd to XML and just search through that, or use a piece of middleware to do the same; - https://www.datavail.com/blog/art-of-bi-converting-the-obiee-repository-file-rpd-into-a-xml-xml-file/