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 - Casting String to date then date to string - Stack Overflow
FILTER("source"."recordCount" USING "source"."snapshot_date" = EVALUATE('TO_CHAR(%1, ''YYYYMMDD'')', TIMESTAMPADD(SQL_TSI_DAY, -7, EVALUATE('TO_DATE(%1, %2)', …
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: 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: …
OBIEE EVALUATE or EVALUATE_AGGR, MAX/MIN Group By
Dec 27, 2018 · I am trying to summarize the table in OBIEE Analysis Tool (11g) using the EVALUATE or EVALUATE_AGGR Function. I have tried using the traditional MAX and MIN …
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 …
obiee - Summing by Column - Stack Overflow
If the required result has to be achieved through OBIEE Answer, then it can be done in following way. Create a table with columns - Category, Date, Amount. Go to Results tab. Edit view of …
OBIEE12c answers encounter an Odbc driver error - Stack Overflow
Aug 24, 2021 · After migrating OBIEE from 11g to 12c, BI answers encounter the following error. Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC ...
obiee - how to pick up a the newest record from a list of values in …
Jan 5, 2018 · I have a requirement to write a code in OBIEE analysis to pick the newest score for a candidate, such that if 01/05/2018 the took a test and scored say 75 then retook the same …
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 …