 Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
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#post1357Including empty queries via decorations in TARGIT Management Studio http://www.targit.com/en...=posts&t=212#post492 |
Best regards
Páll, CTS |
|
|
|
|
|
 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
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
Hi Peter Now I have this scenario in TARGIT Data Service. I have a dimension with two members.  When I choose member a, I lose the date range 18-27. October.  What I want is this. When I choose member a, I keep the date range 18-27. October.  I am able to get the decried visualization using other data sources in TARGIT BI Suite. |
Best regards
Páll, CTS |
|
|
|
|
|
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.