This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Re: Struggles

June 5 2017 at 4:23 PM
No score for this post
TimG 
from IP address 99.66.117.90


Response to Re: Struggles

I hear you, but not even if you tell them "we will provide a *better* solution"?

Say they are pulling all the items that meet a specific criteria. Just for example, "Organic" or "Made in the USA". You systematize that with either a dimension or an alternate rollup and now a) users never have to wonder "is my list up to date?", b) it's really fast, c) everyone who tries to query the same thing agrees on the numbers and d) you don't have to recreate your non-additive formulae (Gross Profit %, or whatever) with Excel math and hope you got it the same as the cube.

Again, I doubt this is telling you anything, Tim, and I'm *definitely* not defending Smart View. By killing the Classic Add-In Oracle created a market for the (superb) Dodeca Excel Add-In. But even the Clasic Add-In wasn't built for data dump retrieves (row and column limits). Essbase - in general - is crap at acting as a bulk data source.

As long as you find an alternative way of meeting the requirement, no reasonable user can blame *you* for what Oracle choose to do, surely?



 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. here's what they do... - Tim Faitsch on Jun 5, 2017, 5:01 PM
    1. Re: here's what they do... - Pete on Jun 5, 2017, 9:32 PM
      1. Re: here's what they do... - Tim Tow on Jun 18, 2017, 11:01 PM
        1. MDX performance - Tim Faitsch on Jun 19, 2017, 8:59 AM
          1. Re: MDX Performance - Tim Tow on Jun 19, 2017, 6:09 PM
            1. Re: MDX Performance - Tim Faitsch on Jun 20, 2017, 9:44 AM
            2. actual results - Tim Faitsch on Jun 20, 2017, 11:03 AM
              1. Leaves? - DrFosterman on Jun 20, 2017, 11:27 AM
                1. Re: Leaves? - Tim Faitsch on Jun 20, 2017, 1:15 PM
                  1. Re: Leaves - Tim Tow on Jun 20, 2017, 3:10 PM
                    1. Re: Leaves - Tim Faitsch on Jun 20, 2017, 3:26 PM
                      1. Re: Leaves - Tim Tow on Jun 20, 2017, 3:42 PM
                        1. Re: Leaves - Tim Faitsch on Jun 20, 2017, 4:37 PM
              2. How is the MDX structured? - Robert Armstrong on Jun 22, 2017, 12:47 PM
                1. sure - Tim Faitsch on Jun 22, 2017, 1:58 PM
                  1. My code - Robert Armstrong on Jun 22, 2017, 2:42 PM
                    1. Re: My code - Tim Faitsch on Jun 22, 2017, 2:59 PM
                      1. RE: second result - Robert Armstrong on Jun 22, 2017, 4:09 PM
                        1. Re: RE: second result - Tim Faitsch on Jun 22, 2017, 4:32 PM
                    2. Re: My code - Tim Faitsch on Jun 22, 2017, 4:01 PM
                      1. Back to basics - Robert Armstrong on Jun 22, 2017, 5:09 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.