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

Groups: Administrators
Joined: 4/7/2011(UTC)
Posts: 514

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:


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:


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


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:


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


BR / Ole
Ole Dyring
Users browsing this topic
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.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.