Skip to Content
0
Former Member
Apr 27, 2014 at 03:49 PM

compression,aggregation,Loading, performance and BI

229 Views

Hi gurus

I am new to SAP BW. I have few doubts which I couldn't get answers by searching forum, please give me answers even if you think below standard question.

After compression, the requested IDs will delete but where the deleted request IDs goes? Is there any chance to get them back?

what about if I want to load delta on already compressed cube? how compression impact on cube after delta?

Aggregates on cube will improve query performance, apart from query response time how do you know query performance increased?

is there any other ways to see/measure performance after aggregates?

how do you know the data in cube coming from aggregates?

Can I load data from two DSOs to Infocube with out routines? If I can please explain the procedure

Example: I have DSO1 and DSO2

DSO1 contain10 fields/Info objects

DSO2 contain 4 fields/Info objects

In my cube level I want load all 14 fields data from DSO1&DSO2

Can you please explain the procedure

How do you know the BI content objects need? (I think its depend on your business requirement)

TIA