TM1 Forum

Hi all

I have a websheet which contains multiple SUBNMs on the same page referring to the same dimension.

I also use hyperlinks with the TITLE parameters to populate these SUBNMs. However I'm unsure how exactly to specify which cell's SUBNM I want to populate.

e.g.

The hyperlink says something like XXX.xls&TITLE_Fruit=Apple&TITLE_Size=Medium

But there are two different SUBNM cells which relate to the dimension "Fruit" on the same page and I only want the SUBNM in cell S99 to be populated with "Apple"

Can anyone help please?

Thanks in advance

In this case I think you have to specify the Location of your SUBNM by specifying the Sheet#, Row# and Column#

Title_S#-R#-C#=ElementValue

For example Title_S1-R3-C2=Canada will pass the Value Canada to the Cell in SHeet1, 3rd Row and Second Column

ardi wrote: For example Title_S1-R3-C2=Canada will pass the Value Canada to the Cell in SHeet1, 3rd Row and Second Column

Actually... just because TM1 likes to annoy us all the numbers are out by 1 - so the 1st sheet, 3rd row and second column would be:
Title_S0-R2-C1

declanr wrote:

ardi wrote: For example Title_S1-R3-C2=Canada will pass the Value Canada to the Cell in SHeet1, 3rd Row and Second Column

Actually... just because TM1 likes to annoy us all the numbers are out by 1 - so the 1st sheet, 3rd row and second column would be:
Title_S0-R2-C1

Thank you declanr, actually after I posted I checked and was about to correct myself but you're way too fast

Hi

It may have been a fluke but when we tried this it only seemed to modify the first SUBNM that it encountered. We had other issues 10.2 so we have not gone much further with testing, but it appeared to be the SUBNM closest to the top left corner.

Regards

Paul Simon

Thanks all!

paulsimon wrote:Hi

It may have been a fluke but when we tried this it only seemed to modify the first SUBNM that it encountered. We had other issues 10.2 so we have not gone much further with testing, but it appeared to be the SUBNM closest to the top left corner.

Regards

Paul Simon

When I was using this approach, in TM1 Versions prior to 10.2, I was including all my Title Elements in the "Navigate To" websheet on the top of the websheet which is usually the hidden area ( Row 1/Col 1, Row 2/Col 2, ect ) and then link them in other visible cells in the websheet. Otherwise, everytime you insert a new row or new column in the websheet, the HyperLink URL would need to be adjusted with the new Row/Col number

Now in 10.2, I prefer to use Title_DimName (for "SUBNM" dimension ) instead of Title_S#-R#-C#, which is easier to maintain but in the case the dimension name repeats in multiple SUBNM cells then Title_S#-R#-C# should avoid the conficts