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

Re: here's what they do...

June 5 2017 at 9:32 PM
No score for this post
Pete 
from IP address 210.11.186.210


Response to here's what they do...

Hey Tim,

yeah - that one is hard.

it would be 'possible' to build some kind of VBA excel front end to use the smartview mdx output to build queries creating dynamic members.

Tim (G) wrote a very good article on the actual MDX.
http://www.cubecoder.com/use-mdx-for-custom-roll-ups-that-respect-ratios-and-variances/

But a possible solution and a good (and supportable!) solution are poles apart - and that is before you have to deal with the performance impacts.

Dodeca could do that for sure - get Jason Jones or Tim Tow talking about dynamically creating MDX queries based upon other queries and you're in for a fun few hours. That said, it's another business change.

P




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

  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.