topic Error when slice in BW Cube is empty in QlikView

Error when slice in BW Cube is empty

pover — Thu, 27 May 2010 20:01:31 GMT

Hello,

I'm trying to create a QVD for each fiscal period in a BW Cube, but I've noticed that the OLAP Connector errors out if the slice of the BW Cube that corresponds to one fiscal period is empty.

Is there someway to check if the slice is empty before trying to load it or a parameter that can be set to ignore the error when the slice is empty?

I attached the error log.

Thanks, Karl

Error when slice in BW Cube is empty

pover — Tue, 01 Jun 2010 06:21:31 GMT

I'm still curious how to avoid the SAP Connector from disconnecting every time it errors out, but I found a workaround to this problem by first seeing what fiscal periods existed in the cube and then in a for loop in the script, I put an if statement to only run the script if the fiscal period exists. That way I avoid making an empty slice and the script runs all the way through.

Thanks.

Error when slice in BW Cube is empty

Thu, 17 Jun 2010 10:05:11 GMT

I found a workaround to this problem by first seeing what fiscal periods existed in the cube and then in a for loop in the script, I put an if statement to only run the script if the fiscal period exists.

Could you share that script, as I think I need to do a similar thing for a loading issue I have.

Thanks in advance.

Error when slice in BW Cube is empty

pover — Thu, 17 Jun 2010 13:01:41 GMT

Here's the file. I hope it helps.

Tell me if you have any questions.

Regards.