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

 Return to Index  

EIS - SQL drill through

February 20 2013 at 11:44 AM
No score for this post
PD 
from IP address 159.53.110.140

 

So, we copied a model and it's metaoutline. We changed the new model to pull our store hierarchy from different table. we deleted the old dimension (from the old table) from the metaoutline, and brought in the same dim (but from the new table). We deleted the drill through report, and then re-created the outline and loaded the data in test.

Then re-created the drill through report. On testing the drill though it now no longer uses the store table in the SQL For example:

old sql

select * from data_table aa, store_table ab
where aa.store=ab.store
and ab.gen6 = 'example store name'

new sql
select * from data_table aa
where aa.store = 'example store name'

This is not the exact sql, but it illustrates the issue. Anyone know what is going on, and how to fix it?

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

  1. Re: EIS - SQL drill through - Gary Crisci on Feb 20, 2:57 PM
    1. Joins - PD on Feb 21, 8:06 AM
      1. Nevermind - PD on Feb 21, 1:48 PM
     
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

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.