You cannot do across multiple columns at same time in analysis. however you can copy/paste the format from one column to another. Use the gear, column properties, on the column you have formatted select copy (1st icon in red). Then goto subsequent columns and use paste (2nd icon in red). This only does the style, however…

These are the formulas…assuming you are filtering on accounting period name, and filter on balance type (ie: A for Actual). Attached is XML for a simple version with prompts for concatenated segment and accounting period name. (Just copy/paste this into new analysis in advanced section, copy the entire file, replace what…

Hi - one other method, if you want to display zero as the result, even if there are no open commitments. Create complex query, and in formula set that value to zero. In second use the measure use formula for total committed cost in 1st analysis IFNULL("- Commitment Cost Measures"."Total Committed Cost",0) in 2nd query, use…

Hi, For analysis, click on the xyz (can do from criteria tab). In window below select display custom message and enter message as necessary.

Hi, See if this works in your instance, you may need both line and distribution sequence for it to appear. You also mentioned about blank, double check you currency settings from the catalog my account → preferences → currency. In our instance I set to ledger currency. Attached is the xml (you can go to advanced and…

In past we had success for multi select parameters (also exceeding 1000 values), using similar to below. in parameter options, choose multiple selection, can select all, NULL value passed AND ((esi.item_number = (COALESCE(null, :P_ITEM, esi.item_number))) or (esi.item_number in (:P_ITEM))) ^^give this a try, we use similar…

I says voting is now open! This is so needed, and so long overdue

Hi, It costs money, but well worth it for our developers, we use sqlconnect https://sqlconnect.com/

Hi, Have you also tried to manually construct the deeplink URL, does that work? https://HOSTNAME/fscmUI/faces/deeplink?objType=Awardoverview&objKey=paraAwardId=AWARDID;searchInd=O&action=EDIT (replace HOSTNAME with your instance and AWARDID with an award ID that you know) If that doesn't work I may suggest opening SR

One suggestion I have had success with, is to use both subject areas in a complex/union query. Filter SL accounting subject area where sources are SL applications, and similar filter GL subject area not to include SL source applications (filter on journal source). Then you can independently build as necessary. So for…

I have quite a bit of experience reconciling PPM vs GL. I'd be happy to setup some time with you over teams. Please send me a message with some of your availability. I work in EST timezone. I found that we were able to achieve by using DFF's on projects that relate to the GL dimension in summary level as start. We can also…

Had same issue, relates to security to actually edit the Award. Had exact same deep link, would not work for me as I did not have edit access on Awards. Worked for another user (same analysis and deep link) who did have access to edit awards. i have not found a "View" action for that deep link. for project ID issue,…

Hi - does the project/task have any revenues/cost/budget? I do find that if there are no measures, after adding in task the project number will disappear from output. This was a screenshot of old SR, and was advised costs/revenue (or budget) needs to have some measure

Hi, Does the data appear within the Project Financial Management section? Also I do know for Projects - Performance Reporting Real Time subject area, the process also should be run: Update Project Performance Data. Try running this process for the project number.

I may suggest creating SR if you still have further issues. Please try the following attached catalog, I added in the measure from cross subject area, added filter for accounting date less than as example. note, i had to remove fields from your original analysis, as some seemed to be based on DFF that is not in our…

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