Hi, What other fields are you adding in beside project, project funding amount and accounting date? I'm seeing same behavior, it's comes up as error just using project and project funding amount. However I did try using same values with subject area Project - Grants Management -Award Funding Real Time, which you should be…

Hi, Maybe try the using the filter in the formula in the measures, instead of adding filter at entire analysis level. Do you have the XML that you can attach as txt file? Like below try the filter in the formula like below for cost, and remove the filter on entire analysis for accounting date. I'm not having the same…

Hi, Do you have multiple/alternate hierarchies (or even base and current) in account dimension? If yes, try adding a filter for the "tree filter" under natural account. (or tree filter for dimensions in layout/etc) Hope this helps.

Is the production instance newer/have data that is not in lower PODs? What is length of all data your are trying listagg together? Just wondering if data in prod exists that is not in lower pod. In one case we used listagg to compile invoices related to a payment. When using listagg, the number of characters exceeded 1000…

also see the attached - this give quite a bit more info

Hi, In analysis design, in order to view I know there are mandatory filters. General Ledger -Balances Real Time subject area is based on Essbase cube -- where there are two mandatory filters to be added -- Chart of Accounts and Period Set Name. ^^^I find you need this filters (and I also use filter on currency). These I…

Thanks so much, it is greatly appreciated as I'm still struggling with performance especially from projects subledger and specifically looking RAW_COST, RAW_COST_CLEARING, BURDEN_COST, BURDEN_COST_CLEARING accounting classes.

I don't believe you would be able to do that within cloud fusion OTBI. However you may want to look into OAC (Analytics Cloud)

Try adding this in prefix SET VARIABLE DISABLE_CACHE_HIT=1; Under advanced tab, do similar, then click apply sql. I have had good luck in the past, but if not I have advised to just close down web browser and restart that usually gets rid of any caching in the session.

I had an odd issue about a month ago, same thing in inquire on detail balances screen. It was intermittent and self-resolved, I had an SR but never found root cause. Suggest trying in incognito mode, see if you can download Also try to clear cookies/temp files (from beginning of time).

We will test this out in our dev environments once patch is applied this weekend. What is the thought, I'm having a bit of trouble to understand the document. Do we need to do anything to keep the export to csv working as it is today? I wasn't sure if default remains as it was or if we need to disable the feature to remain…

And one more suggestion...you can always create an analysis that mimics MPC. Add all the fields needed from Projects Cost Real time subject area, and add the deep link by expenditure item. If you create an analysis that mimics all data in MPC front end and create a deep link on each trx # that should accomplish the mpc…

would suggest just created SR and provide logs/details.

Hi, You can use deep link to expenditure item in MPC syntax: (make sure to replace 'yourserver') i've attached a text file with the URL. Parameter 1: objType: Value: EXPENDITUREITEMDETAILS parameter 2: objKey=ExpItemId, make sure expenditure item is in your analysis, then choose that column for "Expenditure…

Hi - I think you will want to create a variable prompt with custom values for Yes/No. Then add filter in your analysis Analysis filter (Assuming output is Yes/No) Variable Prompt

I had the same issue a long while ago. I believe I just created an SR with Oracle and they were able to cancel.

this would be very helpful

Hi, Please see if you can unarchive this file. Since it also has a prompt the archive allows us to embed the prompt too. I haven't found a way to get the XML for the dashboard prompt. -Rich

I think the issue your probably dealing with are the AP related transactions. They are not accounted in projects, so if you are looking for the accounting on invoices from project costing / GL the do not get accounted from projects to GL. It's AP to GL. I have had some luck using project costing and subledger journals area…

Hi, Most likely you'll want to use master-detail event listener There are also some good youtube videos out there on how to use them.