Daily Cube Free Form Application Setup
Summary:
We are building daily revenue cube as a free form application and I am looking for the setup insights.
Content (please ensure you mask any confidential information):
We are building daily revenue cube in free form and I am looking for insights for the setup. The data source will be BI Publisher report with daily revenue. Data will be pulled back via Smart View ad-hoc and a standard report. MOR_Account and MOR_Department dimensions are reporting dimensions that are using different account-department combinations. These dimensions provide the groupings that are needed for report purposes.
Is it best to have it as just ASO or BSO-ASO?