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

here's what they do...

June 5 2017 at 5:01 PM
No score for this post
Tim Faitsch 
from IP address 166.76.0.1


Response to Re: Struggles

Someone creates some monstrous retrieval. It's got months, quarters, several scenarios, tons of divisions, gobs of products and a handful of accounts. They have another sheet with lookup tables. Then a couple dozen people sit in a room, everyone with their laptops and the sheet. Someone says, "pick x, y, z division in your filter for x, y, z products " and then they talk about the numbers. Since the data pull is a one time deal and Excel filters/adds everything super fast, it's a very good solution for what they're doing.

So essentially they're creating a dynamic list of divisions and products to add up each time. And the lists change all the time -- even within the same meeting. They might talk about one list and then say, "now remove z". I'm guessing this is something that Dodeca could do.

What would be really cool is if the POV in Smart View was multi-select. So imagine being able to, on the fly, add up 15 divisions and 10 products and look at your P&L for that. I know that member on the fly is something Essbase development team has talked about and it's possible, but painfully slow in MDX...

Tim

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

  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.