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.

And one more option if only using analysis. When creating the prompt in the analysis, use a presentation variable. See below as an example, creating a prompt for project number, with a variable named ProjectNum. You can also add filter in the analysis related to the variable Then in the analysis, you can go into something…

one workaround I find, is to create a dashboard with a prompt and analysis that responds to prompt. The prompt and parameters will remain on screen while the analysis runs. In upper right there is gear icon and you can export entire dashboard/dashboard page which will include parameter values in the prompts when exporting.…

Let's keep the momentum going :) now we have 5 :)

this is a good idea

this is a good idea