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 site uses Akismet to reduce spam. Learn how your comment data is processed.

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */