Cubes

88 Topics

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
OSAdmin
4 years ago Place Application Build
4.9KViews
0likes
4Comments
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.
Solved
Elena
2 years ago Place Application Build
4.8KViews
0likes
10Comments
Specialty Cubes
Hello, I am looking to connect with folks who have implemented specialty cubes to manage data for sales, HR, Projects, Treasury, etc. We are exploring the capability of building a digital transformation roadmap using a cube approach, similar to how Essbase can be used. We are considering using the register to utilize larger data sets and other functionalities. Would love to hear your experiences. Thanks! Regards, Ronnie
Solved
RonnieKarpinsk
3 years ago Place Application Build
4.2KViews
0likes
6Comments
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.
benmac360
2 years ago Place Application Build
4.2KViews
0likes
7Comments
Separate Application for Consolidation and Planning
Hi All, Does anyone have the Consolidation and Planning in separate applications? If so, what are the reasons for having them separate or what are the challenges.
RamuV
12 months ago Place Application Build
4KViews
0likes
8Comments
Cube Limit
Hi All, I have a bit of an extreme question here. Is there any limit, whether system or logically, that there are too many cubes in an application? My example (which I have simplified here for illustrative purposes) relates to UD1 for Cost Centers where we have 150 entities all having unique and different cost centers. Since they each have 20 unique Cost Centers, that's potentially 3,000 Cost Centers in one dimension which feels big and very sparse. Thinking through options for how to approach, one option we are weighing is to add a separate cube for each entity and assign a separate UD1 dimension to each cube / entity so they would only have 20 Cost Centers to contend with. As it rolls up the entity structure, it would consolidate to a Summary cube that has one member called 'Total Cost Center' thereby shrinking the data unit in the top cube. Has anyone dealt with these high numbers of cubes before? My gut tells me be that this could be troublesome but sometimes it seems like others are more liberal in their cube assignments. Curious your thoughts? Also, if in another example, there were 2,000 entities rather than 150, would that change your opinion? Is there a line here? Thx, Mike
Solved
miked
9 months ago Place Application Build
3.9KViews
1like
15Comments
Text Values in Cubeview
Looking for help to display Text data in a cube view. I'm using the member filter below which works for every account type EXCEPT DynamicCalc. Account Type set under Settings in the Member Properties (see below). U8#Acct_Text3:V#Annotation
Solved
JenJessel
2 years ago Place Application Build
3.7KViews
0likes
6Comments
QuickView Navigate without data
Hello! As a EssBase previous user, do you know if it's possible to navigate without data or at least positionning row and colums dimansions without a refresh and once all is done proceed to the refresh. Because sometimes when it makes 4 minutes to refresh a cubeview and I have to move at least 5 axis to column or row, it takes 5 x 4 minutes Thank you in advance.
Solved
Vincent
2 years ago Place Application Build
3.7KViews
1like
7Comments
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.
Solved
Vincent
2 years ago Place Application Build
3.4KViews
0likes
8Comments
TransformationEventHandler & ExecuteFileHarvestBatch
Hello, Our transformationeventhandler rule adds missing UD1 members to an unmapped parent. The rule works and has been for a few months. A couple of weeks ago I built a business rule which leverages the utitlity "ExecuteFileHarvestBatch". I have the relevant settings as True. Dim valTransform As Boolean = True Dim valInterest As Boolean = True Dim loadCube As Boolean = True Dim processCube As Boolean = True The batch rule was built so I could schedule the data load. What I am noticing, is when the scheduled job (which calls a DM job with the rule) runs there are failures because of missing UD1 members. If I, then run the import/validate/Load and Process steps manually there are no errors and the missing UD1 members get added. It is as if the TransformationEventHandler is not being executed when the import process runs via the scheduler/dm job/rule. Any ideas for suggestions of where to look?
Solved
SWilyums
2 years ago Place Application Build
3.2KViews
0likes
3Comments