How to use planning user variables in calc manager rules?

Amit
Amit

7:48 PM - Aug 08, 2013 #1

Hello All,

I do understand that how to use user variables in POV and then use prompts in calculation rules to fix on user variable POV. However, in this instance, I am using user variables to drive list of members of rows. A user selects product parent node and the descendants of the parent node are shown in webforms on rows.

Since this user variable drives rows instead of POV, is it possible to use user variable to calculate only descendants of select parent node. Instead of running calculation for full product dimension (sparse), if I could find a way to run these only for user selected product nodes, it should save time on calcs.

TIA
Amit
Quote
Share

Cameron Lackpour
Cameron Lackpour

10:01 PM - Aug 08, 2013 #2

http://camerons-blog-for-essbase-hacker ... nager.html
http://camerons-blog-for-essbase-hacker ... er_18.html

I am a huge proponent of using the focused aggregation approach in BSO Planning apps. I don't know why it isn't taught as standard practice. It is not a panacea for an overly large plan type/database, but it can be very useful.

Regards,

Cameron Lackpour
Quote
Share

Cameron Lackpour
Cameron Lackpour

10:03 PM - Aug 08, 2013 #3

Sorry, misread your post.

You want to pick up the rows. Sigh. Everyone else, too.

Here's a teaser of how it can be done in Dodeca:
http://camerons-blog-for-essbase-hacker ... -with.html

If Planning could drive what's selected on the rows (however it might be done, user variables sound like a good start), then this same technique could apply.

Sorry for not reading your question all the way through. It has been one of those days...

Regards,

Cameron Lackpour
Quote
Share

Anonymous
Anonymous

10:34 PM - Aug 08, 2013 #4

Thanks Cameron. This feature indeed would be really helpful.

Quote
Share

Christian M.
Christian M.

12:52 PM - Oct 11, 2013 #5

http://camerons-blog-for-essbase-hacker ... nager.html
http://camerons-blog-for-essbase-hacker ... er_18.html

I am a huge proponent of using the focused aggregation approach in BSO Planning apps. I don't know why it isn't taught as standard practice. It is not a panacea for an overly large plan type/database, but it can be very useful.

Regards,

Cameron Lackpour
Here what I can suggest:

Step1) Set-up @ planning level
1. Create your user variable in planning (E.g. SelectedProduct)
2. Create your webform with the products on row and the relevant selection (e.g. ILev0Desc(SelectedProd))

Step2) Set-up @ essbase level
3. Create a rtp variable (e.g. MyVar) in EAS with the following settings:
-Type: Members (you need to select MemberS otherwise it will not work)
-Dimension: Product
-Default Value: &SelectedProduct (This is the same name of the user variable used in the form)
Note: The validation of the variable in EAS will fail but you can save it and it works

4. Use this rtp in the BR code (e.g. @RELATIVE([MyVar],0) )

Step3) Attach the BR to the form
5. You can attach the BR to the form and select the relevant options (on-save, take selection from the forms, etc..)
6. You can as well hide the prompt window BUT (BIG "BUT")

- In the version 11.1.1.3 I was able to hide in this way the prompt window
- In the version 11.1.2.2 (with Calc manager) I'm currently struggling to hide the prompt window and I would really appreciate if anybody can give me a solution on this!!!!!!!







Quote
Share

Cameron Lackpour
Cameron Lackpour

3:28 PM - Oct 11, 2013 #6

That would be pretty cool if true. Or it could be yet another example of my colossal ignorance. Probably a coin toss.

I'm getting confused by this line:
>>-Default Value: &SelectedProduct (This is the same name of the user variable used in the form)
^^^Is that leading ampersand indicating a Planning user variable or an Essbase substitution variable?

Regards,

Cameron Lackpour
Quote
Share

Christian M.
Christian M.

4:24 PM - Oct 11, 2013 #7

yes, I'm saying exactly this.

Through this method I'm able to pass to the BR the value of the PLANNING USER VARIABLE! :)

We implemented this 3/4 months ago in our PROD env. and we are doing the same with the new version.
This is tested and it working perfectly! :)

The only problem is that with the 11.1.1.3 I was able to HIDE as well the prompt window and the final user was just pressing SAVE and the process was completely transparent to them.

With the new 11.1.2.2 (where we use calc manager) it pick the PLANNING USER VARIABLE correctly but I can't hide the prompt window.

If you look at the prompt window, after pressing save in the form, you will see in the field &SelectedProduct but if you go ahead it pick up the value of the variable.

Just to be more precise: we do not have any substitution variable with the name "SelectedProduct" so this is really the Planning user variable! :)


Now.. please.. please.. please suggest or help me in finding how to hide the prompt window!!!! :)



BTW ==> I used a lot of information from your blog!! I'm now very happy that I can as well share something new for you!!! ;)

Quote
Share

Dave
Dave

6:36 AM - Oct 14, 2013 #8

Hello All,

I do understand that how to use user variables in POV and then use prompts in calculation rules to fix on user variable POV. However, in this instance, I am using user variables to drive list of members of rows. A user selects product parent node and the descendants of the parent node are shown in webforms on rows.

Since this user variable drives rows instead of POV, is it possible to use user variable to calculate only descendants of select parent node. Instead of running calculation for full product dimension (sparse), if I could find a way to run these only for user selected product nodes, it should save time on calcs.

TIA
Amit
Hi

If you don't mind a bit of real estate being taken up on the screen you could create a composite form:

Form 1, as you have it:
Form 2, the user variable in the POV with some kind of summary data (single row) to make it look like it has some purpose.

Attach your rule to the form with the variable in the POV and it should pass it.

(I have had issues with this if the second form is a Tab and the user doesn’t open it, the rule is not getting triggered on save for some reason so best not to make them tabs).

Cheers
Quote
Share

Joined: 8:50 PM - Feb 24, 2012

3:07 PM - Oct 14, 2013 #9

yes, I'm saying exactly this.

Through this method I'm able to pass to the BR the value of the PLANNING USER VARIABLE! :)

We implemented this 3/4 months ago in our PROD env. and we are doing the same with the new version.
This is tested and it working perfectly! :)

The only problem is that with the 11.1.1.3 I was able to HIDE as well the prompt window and the final user was just pressing SAVE and the process was completely transparent to them.

With the new 11.1.2.2 (where we use calc manager) it pick the PLANNING USER VARIABLE correctly but I can't hide the prompt window.

If you look at the prompt window, after pressing save in the form, you will see in the field &SelectedProduct but if you go ahead it pick up the value of the variable.

Just to be more precise: we do not have any substitution variable with the name "SelectedProduct" so this is really the Planning user variable! :)


Now.. please.. please.. please suggest or help me in finding how to hide the prompt window!!!! :)



BTW ==> I used a lot of information from your blog!! I'm now very happy that I can as well share something new for you!!! ;)
Christian M, Can I steal your idea for my next post, if I share the secret to hide the prompt window :)

You can perform the hide in Calc Manager, if you open the rule in Calc Manager and go to the tab called "Variables", just check "Is hidden" and that's it.

I tried your method in 11.1.2.3 and at first it didn't work. I tried couple of things and at last it started working. (I'm existed to see this working)

1. Logged off after setting the variable default in Calc Manager (By the way, don't use the button in top right corner to deploy the script, it does a validate and deploy, Actions -> Deploy)
2. Trying running the same calc in Essbase by hardcoding the value and then clearing it.
3. Logged off again (just for kicks)
4. Set the variable to a different intersection and test (it starts working)



Regards

Celvin
Quote
Like
Share

Christian M.
Christian M.

5:29 PM - Oct 14, 2013 #10

Thank you!!! it's working correctly! The window desappeared now!
Actually this is the same option flagged in the old version but I did not find it in this new env! :P


Thank you!! Use my suggestion! don't worry!
Quote
Share

Confirmation of reply: