EIS - SQL drill throughFebruary 20 2013 at 11:44 AM
No score for this post
from IP address 188.8.131.52
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:
select * from data_table aa, store_table ab
and ab.gen6 = 'example store name'
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?
- Re: EIS - SQL drill through - Gary Crisci on Feb 20, 2013, 2:57 PM
- Joins - PD on Feb 21, 2013, 8:06 AM
- Nevermind - PD on Feb 21, 2013, 1:48 PM