Dear, What I know is the entire Policy Store (which contain roles in em) exists as a single file called as the system-jazn-data.xml. This file is available under {Middleware_Home}/user_projects/domains/bifoundation_domain/config/fmwconfig directory. Please see if this can help you. Regards Naeem K.

ODI repository is not accessable because he is using weblogic user account. He need to you ODI admin account i.e biadmin to see ODI repository stuff.

Dear, Can you please confirm your EBS version so that I can update which OBIA versions are supported to you (after checking certification matrix). As per the screenshot in your question, I can see you are logged in using weblogic wher ODI repository is not accessable. Here you need to login with odi repository admin user…

Dear, Thanks for your help. I was able to update YTD field using below statement (lowest grain) SUM ( SUM (BUDGET_LOC_AMT)) OVER ( PARTITION BY SUBSTR (W_ACCT_BUDGET_F.PERIOD_END_DT_WID, 4, 4), W_ACCT_BUDGET_F.BALANCING_SEGMENT_WID, W_ACCT_BUDGET_F.LEDGER_WID, W_ACCT_BUDGET_F.GL_SEGMENT3_WID,…

Hi Thomas, I am convinced to implement this through database. However I have spent number of hours to populate a newly created YTD column but couldn't get success with logic itself. Can you please share your thoughts to populate the same through SQL so that later I translate that in ODI. The table name in picture is…

Hi Thomas, Thanks for your response. I understand that approach will solve the problem but interested to know how we can model such type of scenarios. May be the old way can help where we used to create stuff with Time Series wizards but not sure how I can achieve the same. Regards Naeem K.

Hi Christian, Thanks for your response. There are 2 facts involved in the query and both have proper physical and logical joins. (same joins as with OOTB dimention) The column which has issue is not part of Fact LTS contents for both custom & OOTB dimension. If I create new level in the hierarchical dimension for this…

You are absolutely right on the approach. What I meant to say is totally different approach for the same requirements in star way.

Hello, Does your issues is fixed? I have the same issue before which was fixed by creating custom measures in RPD. If you still have this issue then please share expected layout of the reports so that we can understand your objective and suggest accordingly. Regards Naeem K.

Dear, I believe you have already define both sources in BIACM. Have you tried creating 2 domains load each pointing to relevant source (i.e EBS, JD) and executed them? Further have you tried creating 2 Full Load plan selection relevant source and executing them? In my believe above should work fine as we have different…

Dear, In addition to above responses. user4472139 wrote:In OBIA I can run an analysis based solely on the new Presentation table, but when I try to retrieve fields from other presentation tables the query fails with "None of the fact tables are compatible with the query request......"Steven You have to create hierarchies…

Dear You can achieve this by following below MOS Note. OBIEE 11g: How To Extend Usage Tracking Tables S_ETL_DAY And S_ETL_TIME_DAY Past Jan 2016 (Doc ID 2073512.1) Please mark if helpful. Regards Naeem K.

Dear, You can achieve this by Usage Tracking. You can follow below link if not enabled already. (11g) http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html Please mark if helpful. Regards Naeem Akhtar

For point 3, venkat has given you good option. For point 1, you can use OOTB session variable in your default selection of prompts configuration. e.g CRRENT_MONTH For point 2, OBIA period colum has default sortkey defind in repository which actually sort period column from new to old. Not sure why you observe old to new…

I can understand your question. Basically FSM is the application which help you to perform number of actions to implement particular offering. For example if you choose Financial Analytics as offering then you will see links to configuration pertaining to the Finance including some common config. Here you can also use FSM…

There seems you put the question in wrong space. please raise this in relevant spac

The error could be due to mismatch in date format in the condition. other option could be to use variable holding yesterday date in filter. you can assign default value to variable as well in case of error.

Below steps may help. * Duplicate group account dimension in warehouse. * Add a new column named Custom Group Account Name. * Add calculated row name in custom group account. in you case product margin & commercial margin etc rows will be inserted. * Calculated rows WIDs will be inserted repeatedly at row level for as many…