Hi, Below filter will fulfill your requirement. COLUMN_NAME in (@{PRESENTATION_VARIABLE}['@']{COLUMN_NAME}) OR '1'= IFNULL('@{PRESENTATION_VARIABLE}['@']','1') This will help to pick multiple values. If no value is selected, OR 1=1 will pick all values

Hi, Ideally November 1st is the 305th day of the year (306th in leap years) in the Gregorian calendar. So, in the RPD, create a variable 01_NOVEMBER and have the below query. SELECT CASE WHEN TO_CHAR(LAST_DAY(TO_DATE( '01-FEB-'|| EXTRACT(YEAR FROM SYSDATE), 'DD-MON-YYYY')), 'DD') = 28 THEN TRUNC(SYSDATE,'YEAR') + 304 WHEN…

Hi, Can you share the error screenshot so that it will be easy to debug. Thanks, Yaswanth

Hi, You can provide BI Author role to the existing group so that they can "edit" and do a "saveas" of the dashboard or report to their "My Folder". Hope this helps. Thanks, Yaswanth

Hi, Try this.. Create repositiory initialization block (SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY') FROM DUAL;) and dynamic variable accordingly. Hope this helps..! Regards, Yaswanth

Hi, Below is the path for the opmnctl service. Try this.. cd /oracle/middleware/instances/instance1/bin ./opmnctl status

Hi, I think you can write a case statement in the column formula itself like CASE WHEN PRODUCTS IN ('electronics','cellphones') THEN 'XYZ' ELSE PRODUCTS END Hope this helps.. Regards, Yaswanth

Hi, You can drag the Quarter, Month (make this as MAX(MONTH), and the fact. This should work fine. FYR.. Regards, Yaswanth

Hi Ceresa, Thanks for your reply. We have alot of end users accessing the application and even internal technical team access the reports daily. I wonder still there are no reports under this tab. Will this the same in your environment? Or did you see any instance which shows the dashboards or reports under this tab?…

Hi, You need functional resource here who can let you know what balances will come under what category of the target. Else, anyway balance details will be from PAY_DEFINED_BALANCES table, so check with client about the same or source system team on what balances will come under what category of the target. There is an…

Hi Saurabh, In this case, I think you will have new band values in DOMAIN_MEMBER_G table. That's fine as you have added them. But as you mapped only your custom values to source values, only those entries should be there in DOMAIN_MEMBER_MAP_G. Can you check your MAP_G table and show us once the table and the BIACM for the…

Hi, I believe, your client is using data in PAY_RUN_RESULTS and they are expecting the reports based on that. If that is the same, it's needs to be a pure customization which includes elements, input values, run results etc.., Please check once with your clients on the same once. We too implemented the same actually and we…

Please share the complete line of the error UtilSession failed: </span><a class="oracle-k.... Also check once if this document helps OPatch Fails With "LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo" (Doc ID 728417.1)

Please share us the log file C:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch2017-05-10_16-22-11PM_1.log Also there will be logs like biappshiphome_windowsserver_patches.log and Oracle_common_patches.log Please share the same so that it will be easy to debug.

Hi Prateek, Do you mean that you are unable to view the domain members? If we run the domain load, all the source domains and warehouse domains will be loaded into W_DOMAIN_MEMBER_G table. We need to go to BIACM and then map the source and target values accordingly and then after saving, corresponding mapped data will be…

Hi, Have you received any update from Oracle? Please let us know the if there is any workaround.. Thanks, Yaswanth

Hi, It will be easy if you have hierarchy based Organisation table. First dashboard will hold the Org level 0 data. In the next dashboard, you can have the org level 1 data by having a filter "Org level 0 is as prompted". Hope this helps. Thanks, Yaswanth

Hi, In the log, it's mentioned that the invalid repository file. [2017-04-18T09:03:48.305-03:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: c4c] [nQSError: 47007] Invalid repository file: F:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\\empty.rpd. [[ In 12c I remember, rpd exist under…

Hi, In 12c logs will be there in <obiee_home>/user_projects/domains/bi/servers/obis1/logs Check the obis1-diagnostic logs. Can you share us the error message. Thanks, Yaswanth

Hi, Try to start the service adhoc from "em". Also, can you share us the obis1 service log. Log path will be something like below.. <MW_Home>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1 Thanks, Yaswanth