Question:
cube contains 0material, 0vendor, 0customer, kyf
I want to aggregate on 0material, 0matgroup, 0vendor;
where matgroup is attribute of 0material
If I don't rollup a new request in the aggregate, the aggregate is then not activated and not used, is it ?
Answer:
Hi,
if you dont rollup the data after aggregating,you dont see the latest data in the reports until you roll up this request.
Answer:
You can include navigable attributes in aggregates and it is a good thing to do. It's particularly true when the attribute has far fewer values than the dimension through which it is derived.
For example, vendor minority indicator, is an optional classification of vendors that is company specific (small company, woman owner etc.). It only has a handfull of values but is derived through vendor compounded with company, which is not required for reporting and may have hundreds of thousands of values. Including this indicator in a aggregtes effectively replaces a very large dimension with a very small one, which should improve performce even in a complex aggregate that does not summarize the fact table significantly.
Answer:
You can use navigational atributtes in Aggregates. If you don't rollup a request, your query don't have actually information.
For add 0material and 0matgroup use Expert Mode in Update agregates.
GD-Padawan
cube contains 0material, 0vendor, 0customer, kyf
I want to aggregate on 0material, 0matgroup, 0vendor;
where matgroup is attribute of 0material
If I don't rollup a new request in the aggregate, the aggregate is then not activated and not used, is it ?