How to remove currency #EUR and keep #Local amount
Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR amount remains in the system. i have done a force calculate, force translate, (force) consolidate. Nothing seems to remove the EUR amount!? Question: how to remove the EUR amount without touching the Local amounts. thanks!
Org-By-Period in multi-cube application
Has anyone gained experience with the 'org-by-period' consolidation in a multi-cube application? We are currently addressing changes in organizational structure. Specifically, we need to consolidate one of the entities within a single cube up to month 10 and in a different cube thereafter. We have a primary cube and several segment cubes that roll up into it, utilizing the extended Entity dimension. The initial challenge I'm encountering is related to adding the entity to a different cube hierarchy. Does anyone have insight into how to resolve this? Once the entity is added to the second hierarchy, I plan to update the Consolidation Algorithm to 'Org-By-Period Elimination,' set 'Percent consolidation' in both hierarchies, and change the consolidation view to 'Periodic.' I would greatly appreciate any insights on how to resolve the existing error and what to expect or pay attention to in the next steps.
Mid-Year Divestiture Reversing full YTD Data
Hi All, We have a client who wants to exclude a subsidiary from their reporting rollup starting mid year in May 2022. Unfortunately the consolidation view is set to YTD so it appears that when we switch the consolidation percentage to zero then it reverses all of the YTD data for the whole year opposed to just excluding the data beginning in May. Is there a simple solution to resolve this? Or is a business rule required when divesting mid year? It seems like a requirement that should be pretty common and have a pretty straightforward solution like in Hyperion but we haven't had any luck so far. Any thoughts or guidance is greatly appreciated. Best, Joe
Incorrect Consolidated Data
Hello - we recently updated the stored values in the Percent Consolidation property in several large entity hierarchies, so there are 3 stored items with different time periods for each child. We found today that when we pull data using a YTD view, whether in the Excel add on or a cube view within the Windows application, the consolidated numbers on the parent do not match the children when the latest stored value is applied to the child data. However, we did find when the view is changed to Periodic the consolidated parent data matches the product of the child data and the current Percent Consolidation. Is this issue related to the Consolidation View on our Actual scenario? Its currently set to Periodic. If this helps, our Consolidation Algorithm Type is Standard.
Complex Expression in Transformation Rule - How to exit rule?
So we have a UD2 mapping set up in the List section. What I want is to be able to set up a Complex Expression in the UD2 Composite section so that for certain accounts it does nothing and so moves on to the List section, but for everything else we have a hard coded UD2 (e.g. None). I have no problem with setting the criteria in the Complex Expression, but I don't know if it is even possible to write some code that forces it to skip on out and look at the List mappings? I realise this is maybe a bit back to front compared to how the Composite mappings work, but we have a very tight list of accounts where we need to do the List UD2 mapping, and everything else (which can be any other account) should just go to None.
Creating a parent dimension within an existing UD Attribute
Hi We have set up a line of business attribute in our UD3 dimension based on cost centres. It has become clear that in several reports we need to aggregate some of these members. I think the easiest way to do this would be if we could introduce a new layer between the current parent and children. My questions are a) is it possible to do this and if so how? and b) how would this impact reports that are already in circulation? I have tried to illustrate what I'd like to do in the picture below. Thanks
