Search found 2 matches

by mon
Thu Jan 30, 2025 7:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE: Can we use named cells with multiple sheets?
Replies: 0
Views: 6080

PAfE: Can we use named cells with multiple sheets?

Hi, I've a dynamic report within Excel where I want to use Excel's name manager to use more speaking names. So TM1RptTitle("Server:Dim";$L$36) should be come TM1RptTitle(MyDim;MyDimElem) where MyDim and MyDimElem are created using Excel's name manager instead of explicitly referring to a c...
by mon
Tue Jan 28, 2025 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does PAfE fully support alternative hierarchies?
Replies: 3
Views: 7149

Does PAfE fully support alternative hierarchies?

Hi, I'm searching for an answer if PAfE fully support alternative hierarchies. I tried something like SUBNM("Database:Dimension:Hierarchy";;1) in Excel but couldn't get it to work in such a simple case not to mention a more complex situtation with TM1RPTVIEW & DBRW. Is it supported and...