real world hybrid app form performance experiences
Summary:
I'm looking for general experiences with full hybrid (all parents dynamic) cubes . I have a small app, dims having the following counts:
- dim 1: 20
- dim 2: 1,200
- dim 3: 1,400
- account: 1,000
- period,scenario,version, plan element: all typical and small
I have a form structured this way:
- Suppression is enabled
- Page: dim 1,2,3 are all descendants of top
- Column: all periods across 10 years
- Row: 4 rows with specific single member combination of scenario, version and plan element
I'm finding that Hybrid just can't handle that, the form could take many minutes to render. I understand that it's not a substitute for ASO and can store some parents + partial agg. I'm asking more from the perspective of what other's real world experiences have been with full hybrid specifically or do you never go full hybrid because this is typical?