en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Ole  
#1 Posted : Friday, December 5, 2014 11:54:02 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 324

A common request among TARGIT users is to be able to show dimension members with empty results.
E.g., when you are looking at an analysis with 12 months of data in a bar chart, you would like always to be able to see all 12 months. However, filtering to a particular customer, you had no sale to this customer in the two months of June and July.

The default behavior of the database is to display now just 10 bars in the bar chart. To you, however, it is just as important to know which months had no sale. In other words, your bar chart should always display 12 months even though some of these may be empty results with no bars.

To accomplish this you will need to implement a “Dummy measure” in your database that ensures that a value is always shown for any dimension member of any dimension.

The simplest way to implement this is to add a new calculation to your cube. You may name this calculation as you like – in this case named “AlwaysOne” as its function is always to return the value 1:

UserPostedImage

In the TARGIT client, you can now use the AlwaysOne calculation as a measure that you add to objects where you want to see all dimension members – including the ones with empty results:

UserPostedImage

Next, if necessary, you can go to Properties / Visibility to hide the AlwaysOne measure:

UserPostedImage

Finally, you should consider how you would want your dimensions to behave when used for setting criteria. If you do nothing further, the list of dimension members when setting criteria will show all dimension members – including those with empty results:

UserPostedImage

If you want your criteria list to include only those dimension members with data, you should handle this with decorations:

UserPostedImage

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error