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. The …
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)', …
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 line both so …
obiee - How to replace 0.00 values with null in OBIEE12c . my column ...
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 prebuild report
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] [SQL_STATE: …
OBIEE 12c - cannot login to analytics - Stack Overflow
Apr 13, 2017 · Able to access OBIEE Console and EM but unable to login to Analytics. I have already scratched my head over searching for solutions all over. Any suggestion would help here. [Update] - …
obiee - Update agent distribution list - Stack Overflow
Dec 12, 2024 · Requirement: Check distribution lists of all OBIEE agents based off a lookup table. If the email is not present in the lookup table, the email should be removed off the distribution list. How can t...
creating donuts chart in oracle OBIEE - Stack Overflow
Jun 24, 2021 · 0 hello all I'm trying to create a donut chart in OBIEE from oracle , the version I'm using is : 12.2.1.4.0 . please note that our OBIEE is located on our organization network and there is no …
Understanding evaluate function in OBIEE - Stack Overflow
The Evaluate function enables you to send a function to the database to evaluate and return data to OBIEE. For security purposes you must use references in the function rather than the values …
How to export obiee12c users with application roles?
Sep 14, 2021 · exportarchieve utility does not export users in bar file. You need to export security data (i.e., users and applications roles) to a file separately. The following is the way to export security data …