=SUBNM("server:Dimension","Level 0",BA23,"BS Account")
"BS Account" is a string attribute, not an alias, yet when my young padiwan tried the formula above he got the attribute returned. He should be using a dbra, but I was intrigued to see that this worked. Has anyone used this "feature"? I wonder if it's robust enough to rely on (if I could think of a useful application). I would suspect not, especially as the double click feature of the subnm highlights nothing in the subset editor.
Martin
Bug or feature?
-
Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Bug or feature?
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Bug or feature?
An easy one. If you work for IBM it's a feature, otherwise it's a bug. Not sure on the why though.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
kpk
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Bug or feature?
Hi,jim wood wrote:An easy one. If you work for IBM it's a feature, otherwise it's a bug. Not sure on the why though.
Why works:
All the attributes for a dimension are stored in the same }Attribute cube. Probably this is the reason why it "works".
Why remained hidden:
I think SUBNM is usually generated by slicing a View to Excel. Probably this is the reason it has not been realized and fixed yet.
Regards,
Peter
Best Regards,
Peter
Peter