Passing a new active element to SUBNM does not work

Post Reply
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Passing a new active element to SUBNM does not work

Post by bunchukokoy »

Hello experts. Good morning!, however yours is. I need your help. :D

I have an issue in passing a new active element to a SUBNM. Here's the detail. See the attached image.
SUBNM Issue.png
SUBNM Issue.png (14.45 KiB) Viewed 2527 times
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.
Advanced Options.png
Advanced Options.png (9.04 KiB) Viewed 2527 times
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!
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Re: Passing a new active element to SUBNM does not work

Post by bunchukokoy »

Basically, what I want to happen is retain the selected project whether its alias changed or not. Whatever their new position in the subset is.
Post Reply