Check the state of the row in the underlying database schema for your BIP jobs.

The ONLY way to 'mix' $, # % data formats in OBI is to reduce them all to text pre-formatted - and you can then throw away the math abilities. You also now have to build new structures to store the data in it's formatted state and model it through the RPD. OBIEE is not a pixel perfect reporting system. Use BI Publisher for…

I'm with you ... oh, man! ROTFL (MAO is next...)

You'll need to call the report via an external script engine (such as Control-M) and you can specify the output filename dynamically via programming code...

It's what us 'old timers' have learned to do! 

Why OBIEE as a data pump?

* Create Data Warehouse based data model in Oracle Database * Do the ETL (if needed, and practically it is really needed) using ODI * Generate presentation layer using OBIEE Not if you are doing Transactional Business Intelligence ....

I get it ... what IS common between the two is the absolute requirement of sound data model skill and implementation. Both tools, even though they approach BI very differently, rely on solid data models. When I was making a move to add Microsoft it was hinted the models weren't that important - hogwash. Flat out false. The…

MDM EDW OLAP OBIEE are all distinct disciplines ... seems like you are biting off quite a bit in one chunk. will be very hard for you to account for all the details OBIEE does the querying for you based on the model you built. I also work in Microsoft BI - while the principles are the same - the implementation between…

you need a level based measure (total across all details/units) by time slot ... then select max.

Use the audit insert date to the table ... if you don't have one there's your issue - it's a deficient physical model in the database. Easy then to rank on the order of insert dates and filter for rank != 1 ... This also gives you the benefit of: * last row in (filter on a rank=1 where rank is over insert date ordered…

You'll get that in BI Publisher for numbers that are too large (try formatting them) or of you have text (order numbers, account numbers, etc) ... I have found sometimes my report template gets corrupted and it starts showing the scientific format.

what's the end-game? why use obiee for the export? if you need obiee because logic is in the BMM layer, then make the ODBC call straight in and create the CSV via a script ... but still begs what's the end-game. obiee as a data pump is a really bad use of an expensive tool.

Do they have portal (portlet) support? ... you might want to investigate - https://gerardnico.com/wiki/dat/obiee/obips/web_service

Looks like the requirement is to reproduce someone's excel sheet ... not the intent or design of OBIEE. What business questions are to be answered? -- then use the functionality of the tool (OBIEE) to display the answer; chasing after 'requirements' that are to mimic another tool's (especially Excel) way of doing it…

It can ... you just have to model it correctly ... that being said ... I'll echo what the others have said - more info from you is needed. Perhaps post a diagram of your logical model ...

what about setting the target at the yearly average ... then compare to target ... if they both are equal and there's 2, then they are at the average (and green)

Opaque view to test it out ... but not as a permanent solution ... OVs do not get predicate filtering - with large data volumes these prove very unwise.

Sounds like what I'm always saying, "Client has a right to tell you WHAT, never HOW!" +1 @Martin van Donselaar

Your approach should not be to reproduce a query ... ever. What business question(s) is(are) being asked? - model to answer them. OBIEE is not a query tool - its an analytics tool based on logical business models.