You are not logged in.

saving space : replace 0 with Null

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.

akunz

Master

  • "akunz" started this thread

Posts: 53

Date of registration: Nov 21st 2005

  • Send private message

1

Wednesday, October 24th 2007, 1:22pm

saving space : replace 0 with Null

Hi there
in my db i have alot of 0 (not Null) and i want to replace the 0's with Null by looping the db (export and reimport with the excel-import),

i testet with the excelformula (german Excel version)
=palo.setdata(NV();Falsch;....)
=palo.setdata(#NV;Falsch;....)

but it's not working, any ideas ?

michmac

Master

  • "michmac" is male

Posts: 48

Date of registration: Aug 17th 2006

Location: Philadelphia, US

Occupation: OLAP guy

  • Send private message

2

Wednesday, October 24th 2007, 4:54pm

RE: saving space : replace 0 with Null

Hi akunz,

Are you loading 0's to your db? If not, are you sure they are 0 values? See this post:
Delete partly data of a cube

akunz

Master

  • "akunz" started this thread

Posts: 53

Date of registration: Nov 21st 2005

  • Send private message

3

Thursday, October 25th 2007, 8:51am

RE: saving space : replace 0 with Null

hi there, thank's for the link

actually i'm still not happy, following exampel:

We have the value 500.0 at a cube-cell. This consume memory. Now we want to change this value to 0.0
We change the value with an excelformula palo.data( ..) and enter "0" or palo.setdata(0,...), and the question is if palo writes back 0 (this still consume memory) or palo writes back automaticly Null=NoValue (no memory consumption)

To do this in Alea it works with dbset(NV(),...) , is there something simular in palo?

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

4

Thursday, October 25th 2007, 10:45am

RE: saving space : replace 0 with Null

Maybe this helps:

Delete partly data of a cube

I read it like there is no memory consumed by "saving" 0.

Holger
Rate this thread