en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Shun Lu  
#1 Posted : Monday, June 17, 2013 3:04:13 AM(UTC)
Shun Lu
Rank: Member

Groups: extranet\Forum
Joined: 5/28/2013(UTC)
Posts: 9

How can I show the dimension name and all of the measure value by 0 to empty result

Edited by user Monday, June 17, 2013 3:25:54 AM(UTC)  | Reason: Not specified

Ole  
#2 Posted : Monday, June 17, 2013 9:01:09 AM(UTC)
Ole
Rank: Administration

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

Are you asking for how to show empty results?

There is another topic related to this issue. See http://www.targit.com/youtargit?g=posts&t=212

Best regards,
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
Søren Sørensen  
#3 Posted : Thursday, June 20, 2013 3:03:49 PM(UTC)
Søren Sørensen
Rank: Newbie

Groups: extranet\Forum
Joined: 11/14/2012(UTC)
Posts: 1

Shun,
In addition to the answers provided in Ole's link, you could also simply create a new connection to the cube where you 'uncheck' Non Empty Queries under Additional Settings. You've got the Enterprise version of the ANTserver so you can have multiple connections. You would then choose the new cube/connection for those analyses where you'd want to show all dimension members regardless of the measure value ... and the old cube/connection when you only want to show dimension members that have a non-empty measure value. As pointed out in Ole's link, best practice recommendations would be to generally use the old connection; the new connection should only be used when really needed.
Best regards,
Søren

Edited by user Thursday, June 20, 2013 3:43:30 PM(UTC)  | Reason: Not specified

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