Hi all,
I'm trying to identify which reports are dependent on certain query items so that I can inform Report Authors when I am about to ruin their reports.
However, this function (Tools > Find Report Dependencies) only seems to work at the Query Subject level in the TableSpace that I publish to Authors.
In this TableSpace I have shortcuts which then link to the underlying table. For example in each Datamart I have a market dimension which is really a shortcut to the underlying market dimension which is hidden from authors - so that I only have to maintain one market dimension table.
So when I select the 'Deal' datamart and then the 'Market' dimension within it 'Find Report Dependencies' works as expected in that I receive a report which shows me all the reports which contain items from the Market Dimension in the Deals datamart. I guess it is searching all report which contain the string '[Deal].[Markets]'. This is a big list.
What I really want is to be able to select a Data Item in the market dimension, say MarketName, and get a list of all the reports that contain just this item - so the report would contain [Deal].[Market].[MarketName].
However because I use short-cuts I have to go to the 'hidden' TableSpace ([MarketDim]) to select [MarketName]. Running 'Find Report Dependencies' at this point returns no results even though I know there are reports which contain this Item.
What I think happens is that 'Find Report Dependencies' looks for the NameSpace [MarketDim] which is the name of the hidden base table which I shortcut to, rather then using the name in the User View (ie [Market]).
Any ideas how I might get this to work?
Many thanks,
NRH.
I'm trying to identify which reports are dependent on certain query items so that I can inform Report Authors when I am about to ruin their reports.
However, this function (Tools > Find Report Dependencies) only seems to work at the Query Subject level in the TableSpace that I publish to Authors.
In this TableSpace I have shortcuts which then link to the underlying table. For example in each Datamart I have a market dimension which is really a shortcut to the underlying market dimension which is hidden from authors - so that I only have to maintain one market dimension table.
So when I select the 'Deal' datamart and then the 'Market' dimension within it 'Find Report Dependencies' works as expected in that I receive a report which shows me all the reports which contain items from the Market Dimension in the Deals datamart. I guess it is searching all report which contain the string '[Deal].[Markets]'. This is a big list.
What I really want is to be able to select a Data Item in the market dimension, say MarketName, and get a list of all the reports that contain just this item - so the report would contain [Deal].[Market].[MarketName].
However because I use short-cuts I have to go to the 'hidden' TableSpace ([MarketDim]) to select [MarketName]. Running 'Find Report Dependencies' at this point returns no results even though I know there are reports which contain this Item.
What I think happens is that 'Find Report Dependencies' looks for the NameSpace [MarketDim] which is the name of the hidden base table which I shortcut to, rather then using the name in the User View (ie [Market]).
Any ideas how I might get this to work?
Many thanks,
NRH.