Palo Community Forum

Hi,
I got this from the PALO-Crew. Make sure to set a reference to Jedox_Palo_XlAddin in your vba-project. You can use it to clear whole or partitial cube. I think there is nothing to delete the cube vba at this time.

Greetings from Cologne
Holger

Sub VBAClearPartialCube()

Dim obj As Jedox_Palo_XlAddin.IPaloEngineCom
Set obj = New Jedox_Palo_XlAddin.ComInterface

Dim server_database As String
Dim cube As String

Dim Years(1 To 2) As Variant
Dim subcube(1 To 6) As Variant

server_database = "localhost/Demo2"
cube = "Sales"


Years(1) = "2004"
Years(2) = "2005"

subcube(1) = Application.Run("PALO.DIMENSION_LIST_ELEMENTS", server_database, "Months")
subcube(4) = Years

returnvalue = obj.ClearPartialCube(server_database, cube, subcube)

MsgBox (returnvalue)

End Sub

Sub VBAClearWholeCube()

Dim obj As Jedox_Palo_XlAddin.IPaloEngineCom
Set obj = New Jedox_Palo_XlAddin.ComInterface

Dim server_database As String
Dim cube As String

server_database = "localhost/Demo3"
cube = "Sales"

returnvalue = obj.ClearWholeCube(server_database, cube)

MsgBox (returnvalue)

End Sub

Hi,

i have tried this code but it doesn't work.

Error comes up on line:
Set obj = New Jedox_Palo_XlAddin.ComInterface

In German it says:

"Das System kann die angebene Datei nicht finden"

which means, excel can't find the specified file.

Any Help? I need to clear a whole cube via VBA so these lines are important to me.

Thanks

Begges

Hi,

i have tried this code but it doesn't work.

Error comes up on line:
Set obj = New Jedox_Palo_XlAddin.ComInterface

In German it says:

"Das System kann die angebene Datei nicht finden"

which means, excel can't find the specified file.

Any Help? I need to clear a whole cube via VBA so these lines are important to me.

Thanks

Begges

Hi,
check the vba references for Palo_XlAddin. In german you can find it there:
Extras/Verweise
If it is not there set it manually. Its the file Jedox.Palo.XlAddin.tlb

Holger

Holger,

the references are set correctly, the debugger doesn't complain anything in the DIM line, but then in the Set obj = NEW.....

Strange....or?

Begges

Hi,
I truied that out with an older palo.exe. Perhaps it does not work anymore? Got anybody else (perhaps from PALO team) an idea?

Holger

The exchange of palo.exe will probably not work.
What version of the excel addin do you use ?

I use the 1.5 one

Begges

The file 'PaloConfigSchema.xml' is propably not found

It is in same directory as the Jedox.Palo.XlAddin.tlb, where vba references to.

Whats up with this xml file? Do i need to change something?

Begges

You can try to put this file in system32.

If this doen't work, it propably doesn't work with 1.5 for you at all.

no, doesn't work.

Thanks!

Begges