Sandra,
Like Sorin said, the admin help contains all the info you need. I have set this up quit esome times and when you get the message that there is no drillthrough information it seem that the query is able to connect to the table that contains the drillthrough information, but does not return anything matching the variables you put into the query.
-Make sure there is data in your source table
-Make sure that you put the variables correct into the query. Or first try to replace the variables with hardcoded members for which you want to run the query, to test if it gives any result in query analyser.
-Make sure your drillthrough table has columns with membernames that match the exact ID's you have in your dimensions that you use as a variable. For example if you want to query drillthrough info for "SalesUSNeast", make sure this exact ID is
in the drillthrough table. I have seen situations where this was not the case, so we needed to map some columns of the drillthrough data in a staging table to ID's that are in the system, before loading the data to the final drillthrough table.
-Also make sure you don't drillthrough on a calculated member of one of your variables. By default this won't return anything since the drillthrough function does "read" your applicaton hierarchy by default. This can be done, but with a little customizing of the query. I have build a query which was able to do this based on the CTBLDIM tables for the dimensions you use as variable. So CTBLDIMENTITY if the entity is the variable. You can put something in the query like "where entity in (select ID from ctbldimentity where agregat = %ENTITY%)". If you want to run drillthrough queries on calculated members you should put an instruction like this for every variable dimension you have.
Hope this helps!
Joost
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.