The Cubes Tab
The Data Source tab
Azure Data Market
European Central Bank
Google Big Query
Microsoft Office Access
SQL Server Stored Procedure
Windows Event Log
Working With Data Sources
Sharing your data sources or cubes
Date & Time
Math & Trig
Installing Data Service
Configuring Network Security
An easy way to get started is to find two relevant Excel sheets e.g. a files with sales and a file with budget, lets assume that each sheet has a column with a date, customer number and sales amount or budget amount depending on the file.
Go to Data Sources and add each Excel sheet as a new data source, label each file with the appropriate name: sales or budget
Go to cubes and add a new cube
Drag the two tables to the working area
Drag from the arrow to the dot from the sales table to the budget table for the two tables
In the upper right corner of the tables shown in the cube designer you will find a little sum-symbol. Click this icon to make both tables fact tables.
Close the designer and try building your first analysis based on the new cube
HINT: You can do the operation below directly in the cube designer, however going to Data Sources teaches you to explore a part of the application that gives you even greater control over the data sources.
Courage to Act
© 2017 TARGIT. All Rights Reserved.