To add on to @Martin van Donselaar, you need a single logical fact with the physical detail and header tables as logical table sources as well as a logical dimension to setup a hierarchy. This should make the logical fact aggregate aware and at query time dependent on the dimension attributes used (in your case, ID and…

You'll need to provide some basic information to your post. What version of OBIEE, which OS, what errors (if any) have you seen in your log files? Having said that, do you have an ODBC connection to the SQL Server DB on the machine that you're running the OBIEE Admin Tool? When you run an analysis against this data source,…

Could you provide a bit more detail? I'm struggling to understand what your issue is.

Perfect!

A few other people have experienced this in the last day or 2. What time did you notice this?

Your formula must be wrong with the wrong number of quotes to get the single quote. Try: ''''||column

Have you tried pushing this down to the database as part of you DDR SQL?

Hi @aPsikus does this solution work for you? Oracle Support Document 1929503.1 (OBIEE 11g CSV Export Drops Leading Zeros When Imported Into Excel) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1929503.1 https://support.oracle.com/epmos/faces/DocumentDisplay?id=1929503.1

I would raise this directly with Oracle as it may be that the documentation is not in line with the current OBIEE version. If you raise it with them, they’ll up the documentation.

Are you logging onto WebLogic Admin console with a user that is in the WebLogic Administrator group? What do you mean by local user? Have you checked your log files for any clues? Have you also set the virtualize property in the identity store to enable multiple authentication providers? -…

For a list of the new features look here - OBIEE in IL: obiee 12.2.1.4.0 is available Only new OBIEE on premise feature is Theme Management which has been in OAC for some time and as you mentioned, OBIEE and DV integration has been tightened in this release. It’s always a risk with new software but 12.2.1.4 will contain a…

That is correct. Fusion Middleware should be 12.2.1.3 and patch applied to this version

I think you may need to raise this with Oracle as @Gianni Ceresa discovered a checksum issue with the 12.2.1.4 installers last week which could be related to your issue.

Using the custom data format converts the field to a text field when it is exported to Excel. Using the IFNULL(measure,0) retains the measure as a number when exported to Excel. Are you by any chance putting the 0 in quotes in the IFNULL expression?

Could you explain what you mean by: But I am not able to get that Url from static variable. That Url is SSO link href= " '||valueof(PSN)||'saw.dll? ---------------" Does the variable not have any value? How is it set? What version of OBIEE are you using?

The solution you're using converts the values to text. You'll need to convert the NULL to an actual zero. Ideally, this should be done in the source system or ETL but we don't live in an ideal world! The IFNULL should do what you need.

Not more to add to this but maybe you're using the wrong tool. OBIEE is more of an analytical tool as opposed to a data extraction tool.

what is the key for this level in your hierarchy? Is it based on the "BXYZ" column? Is the value unique at this level? If not, then that's your problem.

Hi @Robert Angel. This is a different thread - the other was (Time hierarrchy issue ) and thankfully this isn't a time dimension!