obiee - Casting String to date then date to string - Stack Overflow
Continue to help good content that is interesting, well-researched, and useful, rise to the top! To gain full voting privileges,
obiee - Correct Syntax for optional multi-select parameter in BIP ...
Dec 14, 2022 · I have a query that was written as a Data Analysis in Oracle OTBI, and I am using it inside of BIP Data Model and I am structuring parameters for the Oracle BI EE logical SQL. …
obiee - Passing multiple values through a Presentation Variable in …
Dec 9, 2019 · I have created multiple Direct Database Requests in OBIEE, I am able to pass a presentation variable to a Dashboard Prompt. However I am only able to select one value, if I …
obiee - How to replace 0.00 values with null in OBIEE12c . my …
Aug 13, 2022 · How to replace 0.00 values with null in OBIEE12c . my column datatype is number i need to apply it in RPD or as a self servicing report . it is not require for dashboard and …
Extract project and Report level metadata from obiee12c
Jun 9, 2021 · OBIEE comes with several client tool with the "Catalog Manager" being the admin tool of choice for handling catalog-related tasks like yours. It exists as a GU and a command …
OBIEE: filter that supports "LIKE" and "IN" - Stack Overflow
Mar 7, 2018 · OBIEE: How can I make a filter that supports "LIKE" and "IN", so for example, the user can enter in the analysis prompt either A3% or A31;A34;A3C 1) This works for IN: …
Extracting SQL Queries of all Oracle BI Publisher Reports
Apr 12, 2022 · I have a catalog of OBIEE reports which include many BI Publisher Reports. I want the SQL queries (and eventually the list of physical tables) used in the data models of all the …
Equivalent of max() keep (partition by .. order by ..) in OBIEE
Jun 9, 2021 · In an OBIEE report I want to have one line per agreement with the most recent status as of a certain date for that agreement. One of the dimensions of the subject area is …
OBIEE expression to filter by previous business date
Aug 11, 2020 · I am trying to come up with solution to generate automatic OBIEE 12 report generating automatically for previous business date (e.g. when generating report on Monday, …
obiee - nQSError: 14025 No fact table exists at the requested level …
Jun 24, 2016 · the analysis was working on version 10, after migration to version 11, it started giving error [nQSError: 14025] No fact table exists at the requested level of detail