Anyone have experience with Essbase Studio drill reports that return 1 million + rows?
SummaryAnyone have experience with Essbase Studio drill reports that return 1 million + rows?
I almost think that this is just not even feasible, but I figured I'd ask first. I'm on 220.127.116.11 Windows, Studio version 18.104.22.168.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