TM1 Forum

Im having a problem dumping a cubeview using ASCIIOutput.

I think its related to building the view I want to output within the same TI.

In the prolog I have

DataSourceType = 'VIEW';
DatasourceNameForServer = CubeName;
DatasourceCubeview = ViewName;

In order to change the view to the one I created. But in order to change the output settings for ASCIIOutput I then have to use

DatasourceASCIIDelimiter=' ';
DatasourceASCIIQuoteCharacter=Char(39);

Are these conflicting with each other? When I run the TI I get nothing not even a text file. If I # either set of lines I get the text file.

Although space delimited is an unusual choice for an export there would be no reason why the space character as the delimiter and single quote as the quote character would cause any conflict.

Try using comma as the delimiter and double quotes for the quotes and I bet you get the same result, ... and if this is the case then your issue is that the view you have constructed contains no data.

Thanks for the reply!

I actually used a tab in there since I was trying to make a tab delimited file but the issue I have is odd. I have the view that was created during the TI and I can open in Cube Viewer and see that it has data. I created a new TI to go straight against this view and only dump one variable through ASCIIOutput and I still get nothing. I can't figure out why one view of the cube works and the one I created doesn't.

PlanningDev wrote:Thanks for the reply!

I actually used a tab in there since I was trying to make a tab delimited file

A bunch of spaces isn't a tab; a tab is a specific character code.

I think that the delimiter that you're looking for is Char(9)

PlanningDev wrote:but the issue I have is odd. I have the view that was created during the TI and I can open in Cube Viewer and see that it has data. I created a new TI to go straight against this view and only dump one variable through ASCIIOutput and I still get nothing. I can't figure out why one view of the cube works and the one I created doesn't.

The usual cause:
(a) The view is defined using only consolidated element(s) in one or more of the dimensions;
(b) You have ViewExtractSkipCalcsSet set to On.

If that happens you can see the data (since a view in cube viewer ignores ViewExtractSkipCalcsSet), but it's all skipped when it's used as a data source for the TI process.

Thanks for the help with the Char(9) for a tab. Previously I put a tab into notepad and then did a copy paste into TM1.

The ViewExtractSkipCalcsSet was on for the view and my view was limited to a single consolidated item in one of the dimensions.

Works great now!

Thanks