And thanks for the compliment - feels better than all of the 'badges' you get on the forum! #HashTagReceivedAComplimentFromChristianBergShouldBeABadge

If this is free text then no, not without using java script. Though you could make the prompt populate a variable and then do upper(@{YourVariableNameHere}{DEFAULT_VALUE_HERE) = Your.Columnhere in the analysis that is 'catching' the prompt. If it is driven by a value list then you could convert the value list to SQL and…

lol re "SA."Report AA"

O right, makes sense. I was trying to ascertain if there was something people pulled from Web Reports and OBIEE was just the middle man, or if this truly is an OBIEE analysis...

Understood, apologies and agreed. Analysis :-)

I think I need more than your sentence there, but reading between the lines you are saying 'Why is the OBIEE sql so complex when you would think it would just be select ..... from fact f, time_dimension td where fk.tkey = td.key' - then yes, partly I agree with you (all of that select from select from ... stuff seems…

Hi, it looks like your cache has Essbase in a state where C2681 did not exist, I would suggest it would be worth building into your Essbase database refreshes a post refresh plan to delete OBIEE cache, or put some other mechanism in place to refresh your Essbase cache on a regular basis. I am not following your comment…

Without knowing your rpd modelling I cannot comment on whether it is correct, but yes, the logical model is typically massively simpler than the physical model, I would not see what you are seeing as a bug, merely as an indication of the underlying complexity of the physical model.

Can you show a screenshot or log extract to show exactly what you mean please?

Is there anything in your BI Server log (nqserver.log) to suggest that it crashed? Do you have any core dump files present?

Thank you is like gold here too!! You are most welcome!

Have to agree with Jerry, sometimes the graphs in pivot table view are more flexible than their equivalents outside of pivot table, my only concern with pivot tables generally is they put a lot of the burden of processing on the client and hence aren't as scaleable...

It is the same, there is a display control which allows you to show graph (with table or instead of table)

I fear we may be talking to ourselves, is that what happens when you try to stop someone using a screwdriver as a hammer? ;-)

Final tips to a 'noob' - we are all noobs at something / sometime after all... Do give yourself a meaningful display name, old hands tend to ignore those left on number formats. Do give points if others help you (I am not seeking points here!!!) and mark your questions with helpful / answer - or assumed answered if you got…

Pictures painting a thousand words; - Obviously in your case the columns you are selecting are not as above, just trying to give you the basics of where to find union / union all etc and how to use them...

Yes - it will give you that solution - though you will need to substitute the full syntax for your measure in the sum(case... that I passed to you. In the data pane of answers there is a control near the subject area which allows you to add another subject area (or the same subject area!) by clicking on it, adding the…

Though you might find this useful; - Sounds like there's an email reputation issue and the ISP doesn't want to admit that they've been painted with the tar brush. You might want to check: the ISP's domain reputation, your domain reputation, your ISP's IP block reputation, your assigned address reputation at spamhaus.org,…

Your error is at the outlook end of the solution, not OBIEE, my best advice is work with your local e-mail administrator to resolve.

Hi, create an analysis with your Week 1 / Week 2, then turn it into a union query which uses a sum(case when Measure < 20 then 1 else 0 end) formula for the equivalent numeric column. Use tricks of formatting etc to make it look like a 'normal' total column, job done.