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

report script to display parent-child into two separate columns

February 7 2011 at 6:14 AM
Score 3.0 (1 person)
xxx 
from IP address 202.169.56.229

Hi there,

is there someway to use report script to product report which display parent-child relationship from a dimension into two separate two columns side-by-side ?

e.g

REGION-* and LOCATION-* are from the same dimension

QTY
REGION-A LOCATION-A1 0
REGION-A LOCATION-A2 5
REGION-A LOCATION-A3 7
REGION-B LOCATION-B1 1
REGION-B LOCATION-B2 9

I've read from several thread with suggestion to use outline extractor tool, or vb script. but I want to explore more with report script because it will be an automation process..

Thanks

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

  1. Re: report script to display parent-child into two separate columns - GlennS on Feb 7, 2011, 11:40 AM
    1. Re: report script to display parent-child into two separate columns - xxx on Feb 8, 2011, 4:53 AM
      1. Report Script to get parent and child in two different col - Min on Jun 26, 2012, 1:44 PM
        1. Is your meta-data stored outside the cube? - Daniel Willis on Jun 27, 2012, 2:36 AM
          1. Re: Is your meta-data stored outside the cube? - Anonymous on Jun 27, 2012, 4:05 AM
      2. same issue - Sanju on Feb 19, 2014, 7:10 AM
     
  2. Re: report script to display parent-child into two separate columns - David Welden on Feb 25, 2014, 9:18 AM
    1. Excel VBA - Mike H on Feb 25, 2014, 10:27 AM
      1. How we do this in Dodeca - Tim Tow on Feb 25, 2014, 1:30 PM
    2. Re: report script to display parent-child into two separate columns - Anonymous on Apr 13, 2014, 4:59 PM
     
  3. Gary's blog - Tim Faitsch on Apr 15, 2014, 11:41 AM
  4.  

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.