Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Question on DAC patch
We have a datawarehouse (DWH) with DIM and FACT tables and OBIEE report is build on top of that. The datawarehouse is loaded through Informatica ETL from JDE source system and Informatica ETL workflows are triggered through a DAC scheduler
Currently, as per the requirement I need to add a new column in PRODUCT DIM and make the same changes in OBIEE reports. The DWH changes of adding a new column in PRODUCT DIM (on DIM tables) are done on RPD. In our case in each environment (DEV, QA and PROD) RPD changes are made manually, meaning we pull DEV RPD make changes and save, pull QA RPD and make changes and save and similarly for PROD RPD. (No migration of RPD from DEV to QA and PROD).
Based on the above scenario, do I need to make changes in PRODUCT_D table of DAC also (adding new columns in PRODUCT DIM)? Since we are making changes directly in RPD do we need to import the DAC patch from lower to higher env as part of migration?
Thanks,
Arun
Answers
-
Hi Arun,
Your question is for OBIA. Can you please move it to the correct category?
Thanks!
0 -
Hi Christian,
I did..i am not getting answer anywhere so posting whichever forums i could. Do you know any place or forums where people can answer?
Thanks,
Arun
0 -
These are public forums where people volunteer help for free. Not paid employees or consultants. If it's urgent, open an SR or hire someone to do it. If not - wait until somebody replies.
0 -
Double posting is against the rules of the forum and against the netiquette (yes, it's still a thing).
As Christian said: this is a community forum. People are here on their own time and aren't paid. Posting twice is often a sign that it isn't worth replying because OP isn't going to follow up, posting 4 times is just worse.
As Christian said, do you want an official answer from Oracle? Go through the SR process. Do you want an immediate answer? Hire and pay a consultant.
Do you want an opinion from the community? Play the community game, ask and wait & see: maybe you get a reply, maybe you don't.
Do you want a half-way between community and SR? Ask your question in the MOSC OBIA category: https://community.oracle.com/mosc/categories/obia
But ask only once if you go there.
0
