on 11-13-2007 9:59 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could someone please respond?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.