Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
0. Uses the Oracle Lead function Ex: lead(end_date) over (partition by event order by end_date) as end_date_previous_event, 1. create a function that will retrieve the end date of each previous event 2. creates a flag in the BMM, which will call this function with as parameter (end_date) To invoke a custom function in…
-
i think that recommandation of Syed are right in your OBIEE 12c environment a) In Weblogic Console create Groups BIAdministrators, BIConsumers and BIAuthors b) Now make sure that your Admin User 'Weblogic' is part of BIAdministrators(as this was the default Admin Application Role in 11g) along with Administrators Group and…
-
May not be explicit enough but a comment indicates exactly which line to edit, no need to be gifted to understand. The expert!
-
search <PATH>/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml and do this <Views> <Pivot> <MaxCells>1920000</MaxCells> <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->…
-
In obiee 12c go to /<ORACLE_HOME>/bi/bifoundation/web/msgdb/<language used>/productmessages.xml and change text as below In 11g please find productmessages.xml
-
Connect you to administration-> manage sessions You will see all the users connected and each of the requests sent. If you want to view the physical requests sent directly to the database, you can configure the server logs in the EM to "Accurate" (EM-> Business Intelligence -> Diagnostics)
-
You can create a session variable with a security filter for users so every manager sees what it is entitled to, only once logged in. For automatic sending by mail, let me know if you find the solution
-
use evaluate fonction to execute a custom sql (in Oracle use OVER() function
-
I encountered the same problem on 11g and 12c I advise you to create 2 databases in the physical layer and a single connection pool for each database. After you can make the joins you want between the tables
-
Thanks Syed, To achieve this, my sawlog files should contain the traces of all users who use the platform regardless of the date. However, the sawlog files, which I have, contain only the last 10 connections. So I can not find the connection sought My cache is disabled, however even by activating the cache, I only…