 3,733,521 Users
 2,246,780 Discussions
 7,856,752 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
 17.8K All Categories
 3.3K Industry Applications
 3.2K Intelligent Advisor
 57 Insurance
 533.2K OnPremises Infrastructure
 137.3K Analytics Software
 38.5K Application Development Software
 5.1K Cloud Platform
 109K Database Software
 17.5K Enterprise Manager
 8.8K Hardware
 70.7K Infrastructure Software
 105K Integration
 41.5K Security Software
Error Code: 0b06daf01766453b82a5ffc5530fe18e
Is it possible to have an error code just explain the error? Can anyone tell me what is wrong with this formula?
It is definetly causing a lag in running a consolidation on just one period, though it is rendering expected results.
Thanks in advance!
j
Answers

It's tough to figure this out based on the error alone without knowing your application, but my guess is that formula is flooding your database with a lot of records. You could try an extract calculated data to see why it's saying there are so many records in that sub cube as a starting point.
At a quick glance though, it looks like you have a dimension called PRD in the right hand side of what I assume is an HS.EXP formula. That dimension isn't defined on the left hand side which means that it's going to populate a data point into every member of the PRD dimension. You could be getting warning's related to that, but I'm surprised it's an actual error.
I

Hi Jeo123.
Thanks so much for taking the time to look at my questions. I really appreciate all the feed back you have provided. I agree w/ your statement about the formula is flooding the database w/ a lot of records when launch the consolidation.
This section of the formula (1.00  E#[None].A#A_970000.PRD#[None].CC#[None].W#Periodic.BT#Ending.LOC#[None].I#[ICPNone]) is a constant and only has data at this intersection. The remaining account values have data at multiple intersections (multiple cost centers, products, etc) The results are expected at the multiple intersections of the solve account. Hope that makes sense. So I guess what I am saying is...
I need the formula to hit on all the cost centers and products in part of the formula but only one cost center and product in another part of the formula . Then the results need to populate all the cost centers and products.
Again, any advice is greatly appreciated.
Thank you!
Jen