TM1 Forum

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!!

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.

David Usherwood wrote: b Create an N level 'total' and rule (and feed) it from your consolidated total

Why this step? Why not just include the consolidated node from step a in the view?

tomok wrote:

David Usherwood wrote: b Create an N level 'total' and rule (and feed) it from your consolidated total

Why this step? Why not just include the consolidated node from step a in the view?

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.

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)

Then no need to specify subsets of on every single dimensions in the cube.

since this:
http://www-01.ibm.com/support/docview.w ... wg27048366
it may not be a bad idea to include Consolidations?

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.

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.

Croder

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)

Then no need to specify subsets of on every single dimensions in the cube.

since this:
http://www-01.ibm.com/support/docview.w ... wg27048366
it may not be a bad idea to include Consolidations?

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.

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

Sounds like you didn't do Step b in the instructions David gave you.

Croder wrote:I have the consolidated Total member that was created being ruled to an N Level Element

What that means?

I actually did. It is being ruled and Fed from the C Value.

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.

Its not fed... Not sure why. This is what I have below.

SKIPCHECK;

['Total Measures Export'] = ['Total Measures'];

FEEDERS;

['Total Measures'] => ['Total Measures Export'];

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