Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pover
Honored Contributor

Error when slice in BW Cube is empty

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

1 Solution

Accepted Solutions
pover
Honored Contributor

Error when slice in BW Cube is empty

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 Replies
pover
Honored Contributor

Error when slice in BW Cube is empty

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.

Not applicable

Error when slice in BW Cube is empty

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
Honored Contributor

Error when slice in BW Cube is empty

Here's the file. I hope it helps.

Tell me if you have any questions.

Regards.

Community Browser