Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A kpi with a complex aggr (averaging 10,000,000 detail rows over customer, region).
The customer and sales date are in dimension tables and the sales amount is in a central fact table.
I've thought about creating an autonumber for the customer and sales date.
Would aggr run faster if it was using numerical dimensions rather than string?
What impact do large tables have on aggr? If the customer table was 50 fields and the fact table had 100 measures.
If the aggr was using in a calculation, would variables help instead of having complex expressions?
where are you using AGGR() , straight table or Textbox?
have you considered aggregating the measure during load, instead of front end?
textbox (kpi).
I see - something like this?
AggrTable:
SELECT autonumber(customer®ion,'aggrkey') as aggrkey,sum(salesamount)
RESIDENT
facts
Add this to the fact
autonumber(customer®ion,'aggrkey') as aggrkey
AggrTable:
SELECT autonumber(customer®ion,'aggrkey') as aggrkey,sum(salesamount)
RESIDENT facts
Group By customer, region;
autonumber will help you to reduce the space of your application.
In a dimensional mode, the customer and region are in their respective tables. I think you would need a join clause for the group by, correct?