Ole Dyring
Articles
-
"Advanced" calculations - the 'point and click' editor
”Advanced calculations” is in reality a kind of calculations editor where the end-user can build calculations by pointing to and clicking individual rows or columns in a crosstab. The advanced calc...
-
Pre-defined calculations
The list of pre-defined calculations, called Smart calculations, is found on Smartpad Calculations. The pre-defined calculations has been designed, in an intelligent manner, to add as much value as...
-
User Dimensions with Custom Groups
Sometimes you need to categorize your data in a way that is not supported by your data warehouse. In that case, you will need to work with User Dimensions to create your own categories. In this exa...
-
User dimensions on Criteria Bar
As with any other dimensions, you can also promote a User dimension to become a filtering option on your Criteria bar. Right click the User dimension to add it to the Criteria bar: This feature is...
-
Dynamic captions
The column titles of our cross tab are simply the names that we chose for the User dimension members. From Smartpad Properties we can make these titles dynamic, so that they will show the actual mo...
-
Edit and Share a User dimension
The User dimension you created is probably just a local User dimension – directly associated with the object in which it was created. To edit a User dimension, right click it in the Source data tab...
-
User dimension with dynamic comparison
You can add a new User dimension from the Source data tab: A User dimension is made up of Members. You can add as many members as you need: Each member is made up of its own set of criteria. In t...
-
User Dimensions - explained
A User dimension is a dimension that is created by the end-user. The individual dimension members of a User dimension are defined from criteria from one or more standard dimensions. Quite often, an...
-
Customized dynamic criteria
Even though there is a wide range of pre-defined criteria, at some point you may be in need of setting up a customized dynamic criterion. When working with dynamic criteria in the Criteria Editor d...
-
Dynamic criteria from the Criteria Bar
You can add global, dynamic criteria directly from the Criteria Bar.Typically, most time dimensions will be able to work with dynamic criteria from the criteria bar. However, the time dimension nee...