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
The formula engine supports more than 100 functions that can be useful for adding or changing contents in a data source.
The syntax for the formulas are in nature similar to Excel®, however does have its own flavor with multiple overloads (the date function can e.g. take up to 7 parameters).
When typing in the formulas context sensitive help will popup and you can additionally take advantage of the classic Ctrl+Space feature also found in Visual Studio that enables you to quickly search through all formulas and column names without having to take your hands of the keyboard.
Basic information about formulas
• Functions are always in the form of FUNCTIONNAME() and can be nested.
• Columns names are referenced with an & (ampersand) followed by their name e.g. &Amount
Below is a couple of samples of formulas
To explain the function we will use the dataset below
- Date ProductNo Productname Amount
1999/12/25 1234 T-Shirt WOW 100.25
2013/12/03 4567 Jeans BUZZ 200.30
Retrieve the year part of date:
- YEAR(&Date) Returns 1999 and 2013 for each row
Concatenate productno and productname with a space between
- CONCATENATE(&ProductNo,” “,&Productname) Results in “1234 T-Shirt WOW” and “4567 Jeans BUZZ”
Add Shipping fee of $11 to the Amount
- &Amount+11 Results in amounts becoming 111.25 nd 211.30.
Courage to Act
© 2017 TARGIT. All Rights Reserved.