Error when slice in BW Cube is empty

[pover]

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

[pover · Accepted solution]

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.

[#3]

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.

[pover]

Here's the file. I hope it helps.

Tell me if you have any questions.

Regards.