Question for Asciioutput
-
- Posts: 5
- Joined: Tue Jan 31, 2017 6:52 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Question for Asciioutput
Hello, first time poster here...
I am attempting to asciioutput cube data to a CSV. It is a three dimension cube (Person, Date, Measures). The end result file format that I am trying to achieve is having a column for Person, Date and then a column for EACH measure. I successfully created a view with Person and Date as Row Values and then Measures as Column Values. When using this view as a source for the Asciioutput Process, I can see in the preview that it takes the measures and makes them rows as well.
Desired Output:
Person/Date /Measure1/Measure2/Measure3...
Joe /2016-04-30/ 17/ 5/ 34
Current Output:
Person/Date /Measure Dim/Value
Joe /2016-04-30/Measure 1 / 17
Joe /2016-04-30/Measure 2 / 5
Joe /2016-04-30/Measure 3 / 34
Any assistance would be much appreciated!!
I am attempting to asciioutput cube data to a CSV. It is a three dimension cube (Person, Date, Measures). The end result file format that I am trying to achieve is having a column for Person, Date and then a column for EACH measure. I successfully created a view with Person and Date as Row Values and then Measures as Column Values. When using this view as a source for the Asciioutput Process, I can see in the preview that it takes the measures and makes them rows as well.
Desired Output:
Person/Date /Measure1/Measure2/Measure3...
Joe /2016-04-30/ 17/ 5/ 34
Current Output:
Person/Date /Measure Dim/Value
Joe /2016-04-30/Measure 1 / 17
Joe /2016-04-30/Measure 2 / 5
Joe /2016-04-30/Measure 3 / 34
Any assistance would be much appreciated!!
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Question for Asciioutput
a Create a consolidated total for your measures
b Create an N level 'total' and rule (and feed) it from your consolidated total
c Include the 'total' (only) in your source view
d Pull the values from each measure via Cellgetn
e Add them to the Asciioutput
Pretty standard stuff IMO.
b Create an N level 'total' and rule (and feed) it from your consolidated total
c Include the 'total' (only) in your source view
d Pull the values from each measure via Cellgetn
e Add them to the Asciioutput
Pretty standard stuff IMO.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Question for Asciioutput
Why this step? Why not just include the consolidated node from step a in the view?David Usherwood wrote: b Create an N level 'total' and rule (and feed) it from your consolidated total
-
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Question for Asciioutput
Elementary Watson. So that the source view can be zero suppressed leaf cells. Then no need to specify subsets of on every single dimensions in the cube.tomok wrote:Why this step? Why not just include the consolidated node from step a in the view?David Usherwood wrote: b Create an N level 'total' and rule (and feed) it from your consolidated total
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: Question for Asciioutput
Hi
and what if there are two measures, Measure1 = 100, Measure2 = -100
Then zero suppression will exclude it from the view because the total is 0 (at least my assumption is that if a cell is rule calculated, but fed, but the value itself is 0, then it will be suppressed? let me know if I am wrong, never tested it)
http://www-01.ibm.com/support/docview.w ... wg27048366
it may not be a bad idea to include Consolidations?
and what if there are two measures, Measure1 = 100, Measure2 = -100
Then zero suppression will exclude it from the view because the total is 0 (at least my assumption is that if a cell is rule calculated, but fed, but the value itself is 0, then it will be suppressed? let me know if I am wrong, never tested it)
since this:Then no need to specify subsets of on every single dimensions in the cube.
http://www-01.ibm.com/support/docview.w ... wg27048366
it may not be a bad idea to include Consolidations?
-
- Posts: 5
- Joined: Tue Jan 31, 2017 6:52 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Question for Asciioutput
Thank you, David and to the rest of you. This worked out really well... Not quite standard stuff for me, but was able to get it to work. Thanks so much.David Usherwood wrote:a Create a consolidated total for your measures
b Create an N level 'total' and rule (and feed) it from your consolidated total
c Include the 'total' (only) in your source view
d Pull the values from each measure via Cellgetn
e Add them to the Asciioutput
Pretty standard stuff IMO.
Croder
-
- Posts: 78
- Joined: Wed Jul 31, 2013 4:32 am
- OLAP Product: Cognos TM1, EP, Analyst
- Version: 10.2.2
- Excel Version: 2013
- Location: Sydney AU
Re: Question for Asciioutput
Also, I don't think you can apply this method to string measures. For a small cube like that, only 3 dimensions, I'd use while loops to deal with this type of outputs.mvaspal wrote:Hi
and what if there are two measures, Measure1 = 100, Measure2 = -100
Then zero suppression will exclude it from the view because the total is 0 (at least my assumption is that if a cell is rule calculated, but fed, but the value itself is 0, then it will be suppressed? let me know if I am wrong, never tested it)
since this:Then no need to specify subsets of on every single dimensions in the cube.
http://www-01.ibm.com/support/docview.w ... wg27048366
it may not be a bad idea to include Consolidations?
MK
-
- Posts: 5
- Joined: Tue Jan 31, 2017 6:52 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Question for Asciioutput
Hello again... I have moved my application to Production after all testing checked out in my test environment. When I run the process no data is written. And it has to do with Zero Suppression. I have the consolidated Total member that was created being ruled to an N Level Element. If I manually create a view for the N level without zero suppression on, I see 0's and I see non-zeroes. When I turn on Zero Suppression, no values are retrieved (Even non-zeroes). If I use the C Level Element, it works as intended. Clearly there is something wrong with this.
Thanks,
Nathan
Thanks,
Nathan
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Question for Asciioutput
Sounds like you didn't do Step b in the instructions David gave you.
- vovanenok
- Posts: 88
- Joined: Mon Jun 23, 2014 4:54 pm
- OLAP Product: TM1
- Version: 2.0.9
- Excel Version: Office 365
- Location: Toronto, Canada
- Contact:
Re: Question for Asciioutput
What that means?Croder wrote:I have the consolidated Total member that was created being ruled to an N Level Element
-
- Posts: 5
- Joined: Tue Jan 31, 2017 6:52 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Question for Asciioutput
I actually did. It is being ruled and Fed from the C Value.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Question for Asciioutput
Are you sure it's fed. Open up a cube view and right click on one of the values in this newly created element and choose Check Feeders. Does it say "Not fed". If so then it isn't.
-
- Posts: 5
- Joined: Tue Jan 31, 2017 6:52 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Question for Asciioutput
Its not fed... Not sure why. This is what I have below.
SKIPCHECK;
['Total Measures Export'] = ['Total Measures'];
FEEDERS;
['Total Measures'] => ['Total Measures Export'];
SKIPCHECK;
['Total Measures Export'] = ['Total Measures'];
FEEDERS;
['Total Measures'] => ['Total Measures Export'];
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Question for Asciioutput
Swap the created N-level element with the consolidated element and then zero suppress your view. If items disappear, then the consolidation's components are not fed and therefore the consolidation will not feed either.
Ty
Ty
Ty
Cleveland, TN
Cleveland, TN