Anyone have experience with Essbase Studio drill reports that return 1 million + rows?
Summary
Anyone have experience with Essbase Studio drill reports that return 1 million + rows?Content
I almost think that this is just not even feasible, but I figured I'd ask first. I'm on 11.1.2.4 Windows, Studio version 11.1.2.4.016. My Studio set up is currently hooked into a MSSQL (2008) datamart that is fed from some EBS tables that are a part of the subledger. My users have taken to drilling in on very high level points in our Essbase hierarchy, (Level 3 and up) and are ending up with queries that are trying to return more than 1 million rows. This is crashing Studio, Provider Services, and in the few cases when the query manages
0