block consolidations from a specific Cube View using technical parents
Dear all, Is there a way to block the consolidations if a technical parent is picked? There's a CubeView having the entity tree in rows and consolidation levels in columns. I'd like to only block all consolidations that have a technical parent (this would just polute the database). Is there a code example that could do this? Thank you for the help. Best regards, Carlos
Extracting Journals in a loadable format?
Hi, We're on 7.4. Is there a way to extract a posted journal from one application so that I can easily load it to another application. This would be super useful for investigating issues. At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way. The only options seem to be extracting a .csv file, which has the information but is not formatted in a way that can be loaded again.Consolidation stopped working
The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate only up to the members directly below the top parent. Nothing else has changed, except the data source. This was working as of a couple of days ago and suddenly stopped. I can see it running calcs fine, but the numbers in regular accounts do not roll up. Any thoughts? I've checked all the properties I could think of and turned off all calculations, but nothing helps.
Org-by-period Consolidation | Eliminations
Good Day, In order to implement Org-by-period Consolidation, you need to set the Consolidation View to Periodic so that the correct Share for e.g. the income statement can be calculated for only the period for which an entity was consolidated to a parent. The guidance is clear that "When Consolidation View is set to Periodic and no data is loaded to the IC Accounts for a specific month, custom Elimination rules are required". I assume this is because of built in zero suppression settings on the Elimination data buffer. However, here is what is strange to me and I'm not sure if I'm missing something. When setting the Consolidation View to Periodic and note that No Data Zero View is set to YTD as data is loaded YTD, for any entity, there is a problem with eliminations as follows: When loading 100 000 in January, the full 100 000 is eliminated. If you load 100 000 again YTD in February, nothing gets eliminated. If you load e.g. 100 000.01 YTD in February, then the full amount gets eliminated again. So it seems that custom Elimination rules are not only required when no data is loaded to the IC Accounts, but also if the data loaded in the next month is the same as the prior month?
IC Elimination and USD Overrides
Our Currency Override formula in the Flow Dim (EndBal_Input) has been working great, no issues. We have been using IC Elim's on all of our Balance Sheet accounts except Equity/Investments. All of our E/I accounts are Currency overrides. We turned this IC on in January and are now noticing that the Elim amt is the FX calc'ed value and not the Currency Override value. Thus not zeroing out at O#:Top. Not sure how to adjust the O#Elimination member at the parent level for IC members. Any suggestions on how I might go about fixing. Not sure if I need to include a fourmla in the Flow Dim to handle different Origins or if it is handled elsewhere. Just looking for ideas to think about. In my example below you can see the Elim amount is using the Closing FX rate and not the Fixed USD amt or rate. Clarke
Change the Entity relation property from Dashboard
Hi, Good Day ! I would like to change the Entity Relationship property from dashboard. When the user clicks the button, the metadata associated with the entity relationship property should be updated to reflect the option the user has chosen from the dropdown menu. Can you please help me how can I achieve this requirement. Thank You
