
I have an issue in passing a new active element to a SUBNM. Here's the detail. See the attached image.
The CURRENT block contains the selected project's current attributes, and even the name is actually an alias. (ProjectName range)
The UPDATE TO block contains text fields and filters to be used in changing the current attributes.
The alias value of the project consists the entered text in Project: and the selected item in Business: both under UPDATE TO block.
The MODIFY PROJECT action button calls a process that formulates and assigns the new alias, assigns the new attributes, and at the end, refreshes the feeders.
As you notice there are colored cells in the right side of the image.
BLUE = fixed value 1 (ProjectIndex range)
RED = Principal ID of the selected project under the CURRENT block. It's an alias value that's not allowed to be changed ofcourse. (PrincipalName range)
GREY = It's a DBSS to store in a cube the PrincipalID of the selected project. (SelectedName range)
GREEN = It's a DBRW within a DBRA. The DBRW is to get what was DBSS-ed. And the DBRA is to get the alias (CURRENT NAME) value. (CurrentName range)
In my action button, here are the ff setup:
Calculate TAB - REBUILD SHEET
Process TAB - (Process and parameters). In Options, Calculation is REBUILD SHEET
Worksheet TAB - Ticked Match Title Elements and Replace Current Workbook. Calculation is REBUILD SHEET. In Advanced Options, see the next image. You may be asking why I used RANGE for ProjectName range, but I also used SUBNM... but something did not work.
I first used the first three parameters, the ProjectIndex range was initially used in the SUBNM in the ProjectName range.
I just added the fourth parameter, cause the third did not work. I even tried using only the fourth in the image along with the first and the second, but did not work.
The SUBNM that does not seem to accept the passed element is that of ProjectName range. The ProjectName shows blank, nothing.
This happens when the alias is changed. But if there's no change in the alias, the element is retained there.
The subset used in that SUBNM is an MDX driven. However that is, the new alias does not exclude the element in the subset. It still exists.
The reason I ticked the Replace Current Workbook is that, so to pass default selections in the filter after.
Will you guys help me understand what I am doing wrongly?
Thanks to you all!