Hi all,
I’m currently creating a quick report. It's based on 2 cubes, but it basically relies on data from a single cube (let’s call it “Cube 1”). However, it requires just one specific value from the second cube (“Cube 2”).
I’m considering two approaches:
1) Creating a Separate View for Cube 2: In this approach, I would create a separate view for Cube 2 alongside the view for Cube 1. Then, I could extract the necessary value from Cube 2.
2) Using DBRW to retrieve the specific value frome the "cube 2" and I juste create a single view for Cube 1
My main concern is performance. Which approach would be more efficient?
Best regards,
Perf issue : What is more efficient
- Elessar
- Community Contributor
- Posts: 363
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Perf issue : What is more efficient
For just 1 cell you can use 2nd approach.
For example, I usually do not bother and point to "}ElementAttribute_" cube directly, without making VIEW for it
For example, I usually do not bother and point to "}ElementAttribute_" cube directly, without making VIEW for it