Current Position:Home > Dense dim - dynamic calc

Dense dim - dynamic calc

Update:10-11Source: network consolidation
Advertisement
Hi
Essbase / Planning 11.1.2.1 - BSO db.
We are reviewing our app / db design following implementation last year. One of the things I have noticed is that one particular dense dimension has all members as stored (ie the non-level 0 members are not dynamic calc). Dimension has no member formulas, it is a straight roll up with consolidation for members consisting of (+ and ~).
I have changed this in our dev environment and ran some tests - calc time dramatically improved and total page file size halved (hard disk space becoming a slight issue for us so this is useful).
If we ran with this change, is there anything we need to do or be aware of, other than amending any business rules to exclude calc dims or partial aggs on the amended dimension? It seems a fairly low risk change, but looking for clarification that this is the case.....
The documentation on this states that any required combinations at non level 0 members will be calculated on the fly (eg a user retrieve). Is the same true if a non level 0 intersection is used within a business rule? (testing this on Sample Basic seems fine, again just looking for confirmation).
Thanks
JB

The Best Answer

Advertisement
Yes, the same is true within a rule (i.e. if you reference an upper level in a dense dimension, Essbase will calculate it for you).
I think the only major functional issue that you haven't mentioned is that you need to be sure that none of your existing loads / calculations / user lock & send activities depend on being able to store a value at an upper level - for example, that you never load to a Quarter and then run a calc that allocates down to the Periods.
  • Dense dim - dynamic calc Update:10-11

    Hi Essbase / Planning 11.1.2.1 - BSO db. We are reviewing our app / db design following implementation last year. One of the things I have noticed is that one particular dense dimension has all members as stored (ie the non-level 0 members are not dy

  • Problem at calculation time, when using Dynamic Calc measures Update:10-11

    Hello,<BR><BR>We are using Essabse v6.5 and we want to upgrade to v7.1.<BR>we are performing some tests, in order to check that the Cubes we have created in 6.5 are working properly in v7.1.<BR><BR>the problem that we are exp

  • Error: 1012704 Dynamic Calc processor cannot lock more than [25] ESM blocks Update:10-11

    Dear All, I get the Following Error in the Essbase console when I try to Execute any CalcScript. Error: 1012704 Dynamic Calc processor cannot lock more than [25] ESM blocks during the calculation, please increase CalcLockBlock setting and then retry(

  • Shared members and dynamic calc Update:10-11

    I am trying to replicate a new cube from current GL cube and wish to remove unused shared members if they have any impact on essbase. 2/3 of my accounts (dense) member is stored with the remainder being shared members. Shared members do not add to bl

  • Retrive time with Dynamic Calc Update:10-11

    Hi Experts, My users run a large smart view report which works well However, when they change one of the member on the query to DC member (dense) Then the retrieve takes forever and they getting network error from smart view. I try to figure out , ho

  • Optimizing a dynamic calc Update:10-11

    Hi In our measures dimension we have a MTD member, which is a dynamic calc.The formula is:if (not @ISLEV (Time,0))"AIP-Sales";[email protected]("AIP-Sales",@ILSIBLINGS(@CURRMBR(Time)));endif;The problem is that it takes very long to fetch

  • Problem with a calc involving @MDSHIFT and Dynamic Calc Update:10-11

    Hi all, I have a problem with the calculation of a member in a calc script. The formula of this member is : "R70100" IF(@ISMBR("M01")) ("T_008"->"Cumul"->"HT"+"T_003"->"Cumul"-

  • Function @Parent with Member Dynamic calc Update:10-11

    Hi Everybody, I have a simple Business Rule where i need to assign the Parent value to a child. The parent is a Dynamic Calc and using the function @Parent Essbase doesn't retrieve the data. The formula is as follows: Fix ( Account_1, product_1 Versi

  • Retrieval performance become poor with dynamic calc members with formulas Update:10-11

    We are facing the retrieval performance issue on our partititon cube. It was fine before applying the member formulas for 4 of measures and made them dynamic calc. The retrieval time has increased from 1sec to 5 sec. Here is the main formula on a mem

  • Datacopy from Dynamic Calc member Update:10-11

    Hi All, Within a dense dimension(Accounts) I want to copy data from dynamic calc member to a stored member. Below is the structure of my dimension. Member X (~, Stored) Member A (Dynamic calc, TBLast) ----Member A1 (Dynamic Calc) ----Member A2 (Dynam