zero or nothing ?

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

sebhm

Sage

Posts: 90

Date of registration: Sep 12th 2008

Tuesday, September 6th 2011, 11:39am

zero or nothing ?

Hi,

i have a dimension MONTH :
January : 123
February: 0
March : NO VALUE
April : 456

How can i know that i have no value in March (i have the value 0 as in February and i want to show that it is not the same thing)

Thanks

Go to the top of the page

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

Tuesday, September 6th 2011, 12:51pm

you can't know

a workaround could be a flag you set in an attribute

there are some (older) threads here discussing this "feature" (common in the three in-memory OLAP DBMS I've worked with)

Go to the top of the page

sebhm

Sage

Posts: 90

Date of registration: Sep 12th 2008

Tuesday, September 6th 2011, 3:30pm

thanks for your answer

I am surprised this feature was not implemented yet

Go to the top of the page