on 11-15-2010 11:34 AM
Dear Experts
While executing the query,it fetches data from the aggregated table.We do aggregate on the basis of characteristics(filling up),then how report fetches Keyfigure values.KF values only available in DB level(Fact table),then what is the use of aggregates.
I heard that aggregate table doesnt store KF value,report fetches only from DB level.Is that true?
Any lightings please?
Thanks
Gadhatharan.T
Hi
go through this link for all your answers
http://help.sap.com/saphelp_nw04/helpdata/en/7d/eb683cc5e8ca68e10000000a114084/frameset.htm
Cheers
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the input.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The aggregation is is done on the KF for a characterstic. So the aggregate contains the summerized data for that KF.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You find dim tables and a fact table for each aggregate you build. So, you actually have kf values stored in the aggregate tables.
Regards,
Fred
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
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.