en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Páll Bjarkason  
#1 Posted : Monday, February 15, 2016 3:44:22 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

I need to include empty queries in TARGIT Data Service, such that I always show the week in a crosstab, regardless if there are data in the particular week.

In TARGIT Management Studio's decorations settings, the individual database connection can be tweaked to return empty queries.

Is there a similar settings method using TDS or is tweaking the relational data the only workaround?


I understand that a ShowAll feature will be available in TARGIT BI Suite in coming releases. Will it function with TDS cubes?



Implementing ShowAll measure using SSAS
http://www.targit.com/en...posts&t=489#post1357

Including empty queries via decorations in TARGIT Management Studio
http://www.targit.com/en...=posts&t=212#post492
Best regards

Páll, CTS
Peter  
#2 Posted : Tuesday, November 1, 2016 6:36:15 PM(UTC)
Peter
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 43

You could use the "*.cnt" measure that automatically is created.

Here's a link to a screenshot showing the measure:
https://i.imgur.com/oMNcpvM.png
Páll Bjarkason  
#3 Posted : Wednesday, November 2, 2016 1:19:14 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi Peter

Now I have this scenario in TARGIT Data Service.

I have a dimension with two members.
UserPostedImage

When I choose member a, I lose the date range 18-27. October.
UserPostedImage


What I want is this.
When I choose member a, I keep the date range 18-27. October.
UserPostedImage

I am able to get the decried visualization using other data sources in TARGIT BI Suite.
Best regards

Páll, CTS
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