keplan
asked on
PArtitioning SSAS CUBE by monthly
Hi,
I have 1 million customers in s dimension table and fact table contain monthly cusomters invoices
by each customer, at this moment if I brows the cube by all customer, it started 'no response'
how do I improve this persomance, by intorducing partition?
thanks in advance
I have 1 million customers in s dimension table and fact table contain monthly cusomters invoices
by each customer, at this moment if I brows the cube by all customer, it started 'no response'
how do I improve this persomance, by intorducing partition?
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER