Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Eduardo, You can use "BETWEEN" operator to display the values between 2 dates. The below mentioned example shows date between current_date -4 and current_date. "Time"."Date" BETWEEN timestampadd(sql_tsi_day,-4,current_date) AND current_date Or else add an "AND" condition to achieve the same. "Time"."Date" >=…
-
Hi Mik, Try the given formula in Advanced SQL filter. Logic is during Monday's we will subtract 4 from current_date and in the filter we use "greater than". "Time"."Date" > CAST(CASE WHEN dayname(current_date)='Mon' THEN timestampadd(sql_tsi_day,-4,current_date) WHEN dayname(current_date)<>'Mon' THEN…
-
Could you please share the column formula for that particular column ?
-
Hi Divya, Are you trying to display the last updated record? Last updated record may not be always equal to the last created record if your design allows updates to existing records. If data datatype of your date column is timestamp, then you display the latest record using the RANK function. RANK(LAST_UPDATE_DATE BY…
-
Did you get a chance to look at Doc ID 1967801.1 ?
-
Joel, Did you check this support doc. OBIEE 11g - Unable To Start Opmn Javahost Service using ./opmnctl Startall (Doc ID 2025967.1)
-
Hi Joel, I faced multiple issue while running cionfig.sh. In my case, provisioning.log file helped me identify the root cause of the issue. Did you see anything in provisioning.log file ? Path : /middleware/instances/instance2/diagnostics/logs/OPMN/opmn Thanks Ebin
-
Hi Eric, I don't remember using this in 10g and also don't have a 10g application in front of me.
-
Hi, Convert millisecond to second and then use custom strings in OBIEE to convert seconds into dd hh:mm:ss format. Use the Custom Numeric Format as [duration(sec)][opt:dd]:hh:mm:ss https://docs.oracle.com/cd/E28280_01/bi.1111/e10544/format.htm#BIEUG11528
-
Hi, Try generating Agent report from OBIEE catalog manager with columns Name & Email. Thanks Ebin
-
Hi Kzane, I tested the scenario you mentioned in 2 different obiee versions - 11.1.1.7.0 & 11.1.1.9.160119. Both version redirects me to the dashboard page specified in My Account on login.
-
Are you looking for Viewing BI Publisher Report History ? http://docs.oracle.com/cd/E23943_01/bi.1111/e22257/view_manage_rpt_his.htm#BIPUG236
-
Hi Bishnu, What is the actual issue you are facing while formatting the report ? It would be helpful if you could attach the screenshot of the issue. Thanks Ebin
-
Hi, The only way I can think of is to use Conditions in Agents to send report email on 5th business day. The disadvantage with this approach is, Agent need to be run on multiple days in addition to the 5th business day. For example Agent is scheduled to run every day from 5th to 10th of a month and then in the condition…
-
Hi Mik, You can use custom strings in OBIEE to convert seconds into hh:mm:ss format. Use the Custom Numeric Format as [duration(sec)] hh:mm:ss https://docs.oracle.com/cd/E28280_01/bi.1111/e10544/format.htm#BIEUG11528
-
Is it happening after new data is inserted into the warehouse table ?
-
Hi, Have you performed the below mentioned step ? Upgrade Web Catalog Objects * Login to BI Answers as weblogic user * Update Catalog Objects (click Administration->Scan and Update Catalog Objects That Require Updates->Update Catalog Objects)
-
I Checked up the data lineage for you. In the OOTB mapping, the column you mentioned above is sourced from Siebel table S_AGREE_ITEM and column NET_PRI. There are some conditions applied on top of this on the target mapping. Check the Informatica mapping to identify those.
-
Refer Oracle Support Doc Oracle Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6.4 (Doc ID 1527475.1)
-
It's not a Siebel Column. You need to to track back to the staging table and then look at the Siebel section in the data lineage. Siebel table name start with S_