Is your incremental not running properly?

Users who are using Answers should be well trained ... else you'll have people building stuff that doesn't work or doesn't perform well which affects the quality of your BI Portfolio. The advanced calculations that users need should be built in the RPD or if possible pushed back to the database. Front end manipulation of…

I think the error you get is telling you NO ... the timeseries functions should need to be nested to achieve what you are trying to do. AGO(AGO("License Revenue"."Revenue (Constant Dollar)",1),1) why not? <strong>AGO("License Revenue"."Revenue (Constant Dollar)",2)</strong> <-- 2 periods AGO; based on the granularity of…

Use of information drive physical data model design ... AND always design for performance. If you hare forced to nest logical functions like this you have a bad physical design given the requirements. You can either go the route of creating a fact table that has all this pre-calculated or you could re-up your date…

It's all contained in the documentation ...

Great points by Gianni! Or you could store the ago value in the same row in the fact in it's own column ... two values out of a single row fetch. You have quite a few options for performance here.

Check with your Oracle Rep ...

if you are 100% positive you won't get multiple rows per day per (rest of grain) then you can add the timestamp WID as an extended column ... example: X_BILL_DTTM_WID

I don't think so ... you'll have to load the Universal Adapter files for ingestion into the OBAW schema.

"populate the WID in Fact for W_TIME_OF_DAY dimension" That's your best course of action ... you are changing the grain of the fact table so use WIDs ... so you might want to take a fact table and 'copy' it then extend; example: W_XACT_F copied and named custom -> WC_XACT_F 

https://docs.oracle.com/cd/B34956_01/current/acrobat/120dbiig.pdf found with a very simple google search ...

1. BIAPPS knowledge modules only shipped and licensed with BIAPPS ... they are specific to moving the data from support sources into the predefined OBAW structures. 2. Some staging data is persisted to facilitate data change capture 3. No silver bullets (thx - RMOFF); when discussing performance specifics are a must. What…

Are you planning on leveraging the OOTB OBIA security model or setting up your own (simplifying)? The former is what requires the OID certification for support. 

Customize the content of the integration_id so you don't get duplicates ... if you don't want to follow that, then open an SR with Oracle and reference the one dealing with PSoft.

try using this version of your query: SELECT c.CASE_ID , NVL(C.CASE_AMOUNT,0) AS CASE_AMOUNT, C.CASE_NO, C.CONTRACT_NO, C.CASE_TYPE_ID, TO_CHAR(C.CASE_FILED_DATE,'DD/MM/YYYY') AS CASE_FILED_DATE , C.DATE_KEY, C.LOCCODE, 'BAL_FRM_LM' AS STATUS FROM DM__LEGAL_CASE C , DM__CASE_HISTORY H WHERE C.CASE_ID = H.CASE_ID AND…

Looks like you need to fabricate/customize to ensure uniqueness across parent/child. If I remember right, uniqueness is achieved through the INTEGRATION_ID - you might have to add a column component to that to ensure it.

There is no pre-built connector for OBIA Student Information Analytics (SIA) that I know of for Banner ... so you will have to implement SIA via the universal adapters (the files). OR you can build your warehouse from scratch OR you can buy Ellucian's EDW solution.

you can import XML data into excel ...

How to export workflows and mappings in informatica through unix shell script? - Toolbox for IT Groups

In LDAP server users might/might not be put into groups... In Weblogic the security provider is configured to your LDAP In Enterprise Manager users and/or groups are membered to BI Application Roles; you can see the memberships there