Search found 2 matches
- 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...
- 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...