Intercompany security issue across cubes
Originally posted by Katarina Sterley We have 4 extensions to our main cube and now we have a problem with the standard intercompany matching reports. The end users do not see the transactions on the lowest level from another cube. They only see the IC transactions within their own cube. If they look at the main account they see the transactions but that is not displayed in the standard intercompany matching report within the workflow. Like this from quickview: From Workflow report: Any suggestion on how we should solve this? Kind regards Katarina
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.
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.
QuickView 'Where' condition
Hi the community! Do you know the way to proceed to retriev in a cubeview a specific UD where the text of it is set on a specific value? For example I want at the finest level all my UD1 which contain as a Text4 "Long_Lines" I write this as a formula : U1#Shipping_Trade.Children.Where(Text4=Long_Lines) But nothing appears as a result. Did I missed something? Thank you.
