Dimension Mapping
-
Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Dimension Mapping
Does anyone already have a method to map out the elements of a dimension including a readable portrayal of the hierarchy? I have used an excel based method for some time but it's not brilliant, especially with large hierarchies. My own attempt didn't work out so well so i was wondering if anyone else had a way to show structures?
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Dimension Mapping
Sigh, you couldn't have asked this 6 hours ago when I was still at work, already...Steve Vincent wrote:Does anyone already have a method to map out the elements of a dimension including a readable portrayal of the hierarchy? I have used an excel based method for some time but it's not brilliant, especially with large hierarchies. My own attempt didn't work out so well so i was wondering if anyone else had a way to show structures?
Yeah, I have something but it's in my Personal.xls workbook at the office; I don't have a copy of it here. Essentially it spits out an indented tree structure into one or more Excel worksheets. The only thing that I hadn't finished in it was an optional parameter to show weightings to the right of the element name.
If no-one else has posted anything by Monday I'll whack it up then.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
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: Dimension Mapping
If you could post that up here (Or in handy code) it will be very useful,
Jim.
Jim.
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