I created a calculation script which fixed on accounts in plan type 1 only and the calculation suppose to calculate a "dynamiccalc" account with a member formula attached. Everytime I run the script, it takes very long time and I found there are sessions at the back of essbase with "Process local xref/xwrite request" request to other plan types.
It does not has this kind of session if I change the account to "store".
Would like to check, is it possible to create a dynamic calc account to calculate for only 1 plan type in a multi-plan type application? Is there any special setting that I need to do to enable this? I already selected source plan type as Plan type 1 for my dynamic calc account. Please help!
So are you saying you want the account to only "exist" in one plan type? If so, simply edit the account's properties, and remove it from the other plan types. (There's a check box next to each plan type. Uncheck, refresh, and it will be removed.)
Or are you saying you want it dynamic in one plan type, but stored in another? If this is the case, then you can't do that. The data storage setting applies to all plan types.
Thanks for pointing out the check box. Overlooked it and the checkbox was not unchecked, even I only wanted the account to exist in 1 of the plan type.
However, after I unchecked and refresh now, when I run the calc script, it still trigger process at the back to the other 2 plan types with "Process local xref/xwrite request" request. What else could I have missed?
I already added the "HSP_Nolink" UDA to all accounts in plan type 2 and plan type 3 and confirmed that there's no account with "Xref" member formula, I really don't know why it is trying to process local xref request. Can anyone help??
If you add the HSP_NOLINK UDA after you're initially done a refresh, I wonder if perhaps it won't remove the XREF formula already placed on the accounts in the target plan types??? This is just a guess. If you edit the outlines using EAS (on the target plan types, not the source plan types), do you see the XREF formulas there?
One other tip . . . in EAS you can search formulas. Edit the outline, right-click on your Account dimension and select "Find Members". In the "Match Text In" box select only "Formulas". Then search for XREF. I would do this against all of my databases to figure out where the XREF is occurring.
This isn't a "solution" per se, but it might help you diagnose the problem. What happens if you temporarily remove the Location Alias in EAS? Do you get any more specific errors? The XREF's need the location alias to communicate with the other databases. If you right-click on the database, and select Edit, Location Aliases, you'll see them. If you temporarily remove these (make sure you have the correct information to replace them later), and run your calcs, you may get specific calcs to fail, helping you locate the source of the XREF's.