But is the underlying field text or date? And, if you don't know / cannot find this out, can you try putting a format on the date that includes the year element to see exactly what is stored in the source database?

In your first example you don't give a year - "showing correct (17-may)." - what is the value in the OBIEE analysis, is it a date field or is a text field and exactly what is the value there?

Hi Mia, group by is what OBIEE does as standard to all dimension fields, all you need is a suitable Fact measure like 'Count of People' and you are there, but unable as I am to see your subject area I cannot be more specific...

I agree, I am not the biggest fan of Agile, but the model, feedback and refine loop does work well in BI circles, and does result in the client understanding the potential benefits and costs of OBIEE, rather than just giving you a long list of 'this is what we have always done'.

There is an English joke to the effect of; - "Man in car - What is the best way to Leicester from here? Local - I wouldn't start here if I wanted to go to Leicester." That is my best advice for this situation, don't start here ;-)

Sounds more like a network issue - check with your local IT on firewalls etc would be my advice.

As well as Joel's suggestion of by-passing the cache I would also try using 'server complex aggregate' to calculate your totals if this does not do the 'trick' for you.

Looking at the code that you have not 'redacted' I see an awful lot of data type conversions going on, particularly around your dates. You do not show your where clause, but if that is similarly reliant on converted data types then I would suggest that you need to invest more time in ETL to solve your underlying…

See => Hierarchical Columns & Graph Drill Down Appending Issue Did you construct your graph with the hierarchy as described in the hit above?

On your first question when you use this functionality what happens is the underlying analysis is dynamically re-rendered to be filtered to the value you clicked on and adds the child member (key or descriptive equivalent) to the presentation. Using the back arrow will revert you to the pre-drill condition, I don't know of…

It always amazes me when end users heavily invest in a new BI tool, just to then want it to deliver exactly what they always had. Progress is not buying a plane and driving it down the motorway because that is the way you always went... I know it is an uphill struggle sometimes to re-educate an end user base, but it a…

Have you reviewed => https://www.databaseusers.com/article/5998747/Cannot+read+tile+layer+config+log+from+database

Hi, OBIEE is not excel. It is not now. It is not meant to be. And I pray it will never become, excel. If the bottom line is that you really need it to be excel then use Smart View, get your figures in the broad presentation and then use something like visual basic to dress up the rest. If you really need true reports, then…

Turning your requirement on its head, what are you doing in a pivot table that you cannot achieve in a table for this?

Though come to think of it OBIEE can feel like self-mortification some days...

lol - and forgive the typo!

Hi, I did mean with a single analysis, the copy part was purely as the user might want to retain a version which is more 'ascetic' to look at, for non-download purposes.

What I am suggesting is that you could create an 'export' version of your analysis as a workaround. i.e. Copy your existing analysis to a new name. Open it in answers. Use formula editor to concatenate the fields together by Opening Field 2 with formula editor, copy the formula, edit field 1, change its formula to be…

If this is just for one file then you could also concatenate the output into a single field; - field1||';'||field2 etc

Hi, you have a case statement in OBIEE you also have a DayOfWeek function. OBIEE: Calendar Date/Time Functions IN OBIEE So, not hard to do the equivalent.