DataSourceCubeView: Syntax, Use and Example

Another piece of the puzzle of setting up an AsciiOutput is to define a view and then export that view.

Why would you do this?  Well, you can either go through a series of IF statements in your metadata or data tab checking each record to see if it satisfies a long list of criteria (e.g. if the Account is Sales and if the Scenario is Actual etc.), or you can define a view in the prolog and then use that view for the AsciiOutput.

Syntax of DataSourceCubeView

The syntax is DatasourceCubeview=’ViewName’; – very simple eh!

The trick here is to define your view in the TI, then set the data source to this view.

Example

On Prolog:

DatasourceCubeview=’SourceView’;

On Metadata or Data

AsciiOutput

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in TI Functions and tagged ASCIIOUTPUT, DataSourceCubeView. Bookmark the permalink.