Process Chain

[Former Member]

Hi,

I want to compress a transactional cube via process chain. Aggregates are available for this cube.

Which process types to include? We have a process chain for the compression purpose. It doesn't seem to be working. The process types we are using are: Start Process -> Roll up requests (older than 1 day) -> Compress requests (Older than 1 day). These requests are in green.

Thanks.

[Former Member · Accepted solution]

Hi,

compression of info cube as to use, but you have this in process chain already it seems, if the requests are compressed you can see a Tick mark in info cube manage screen. check for the same.

Regards

Sankar

[Former Member · Accepted solution]

Hello Sankar,

I do NOT see the compressed infocube, compressed aggregate and rollup aggregate columns checked in the manage of the infocube even after scheduling the process chain.

Thanks

[Former Member · Accepted solution]

Have the aggregates been filled any time? If not,try activate & fill option in aggregate maintenance screen to ensure that there are no issues with aggregates & that the issue is with the definition of process type in the process chain...

[Former Member · Accepted solution]

I would be suspicious of the aggregates as well. If the Request is Green and more than 1 day old, it should have rolled up. If you have a rollup issue, that would prevent the compression. I would try running the rollup from the manage tab to see if the rollup works from there - perhaps there is something else in the process chain that isn't quite right. Then if, the rollup works, the Request should be marked as being available for reporting and you can then try to run the compres from the manage tab as well.

Normally, you would not specify a number of days for the rollup step, you usually want all Requests rolled up into the aggregates. If the request is in the base cube, you would want it in the aggregate, otherwise the Request in teh base cube is not available for reporting.

[Former Member · Accepted solution]

Hi Guys,

The aggregates do have data. I checked the data.

If i manually do 'Roll Up' and 'Compress' from the manage tab of the infocube, I am able to. But, when I try doing the same through process chain, it doesn't work. As i mentioned earlier, my process chain has the following sequence:

Start Process -> Roll-up cube -> Compress cube

This is a planning cube not basic cube.

Thanks

[Former Member · Accepted solution]

Hi George,

did you find a solution already?

I think I do have a similar problem.

I thought to switch the cube to "loading" and then do the compress. But in my system the request does not turn to green, but stays in yellow.

I wonder wheather is some trick to get the request closed.

Or do we still have to use the reports we used already in BPS - switch cube to basic and then back to transactional?

please tell me, what you think about it.

regards

Cornelia

[Former Member]

George,

your best bet would be change the transactional cube to basic cube do your compression and then switch it back to transactional cube.

Hope this helps.

Alex (Arthur Samson)

[Former Member]

Hi,

Could someone please respond?

Thanks

[Former Member]

Hi,

Please advise.

Thanks