Hi Gurus,
we are upgraded the report studio reports from 8.4 to 10.2.1, so after upgrade we are facing the issue with the Drill through.
that means in the source reports we created the tree prompt then when we passing these parameters to target reports it is re prompting the tree promt for target reports.Actually it shouldn't display re prompt.
this is the issue we are facing .please suggest me..
Thank You.
Hi,
If you go into the drill-through definitions property in the source report, have you verified that the appropriate items are being passed? What happens if you use layout calcs in the target report to display the passed values? Are the values you expect being passed through?
MF.
Hi,
Thanks for reply.
in the source report drill through defination we are passing correct items.
but it is asking only for tree prompt selections in target reports when we choose lower level members in the source report. if i choose higher level it is not prompting and reports running fine. (Issue only with Tree prompt)
Quote from: prasad23 on 19 Feb 2014 12:40:59 AM
Hi,
Thanks for reply.
in the source report drill through defination we are passing correct items.
but it is asking only for tree prompt selections in target reports when we choose lower level members in the source report. if i choose higher level it is not prompting and reports running fine. (Issue only with Tree prompt)
What happens if you use layout calcs in the target report to display the passed values? Are the values you expect being passed through?
in the layout calculation it is displaying correct values what am selecting...
What syntax are you using in the target report to drive your tree prompts? Can you give us an example? I suspect your epxpressions are focusing on a level rather than the entire hierarchy...
MF.
1)i used this syntax in layout calc for displaying the values.
ParamDisplayValue('parameter')
and
2)rootMember([namespce].[dimens].[hierarchy]) expression for Tree prompt
Hi,
What I mean is - in your target report, you will have a report expression that references the parameter - something like
[Hierarchy] -> ?Param?
or
[Level] -> ?Param?
Can you tell us what the expression is?
MF.
hi,
Once again i wish to explain my issue for clarifying whether we are in same page or not.
Actually we have level 1(source) and level 2(target) reports, in the level1 we created the tree prompt and passing these parameters to the level2 reports. what are the values selected in level 1, it must be display the data in level2 with out re prompting. but it is prompting for the level2.
Expression for the Passing parameter is : [Hierarchy] -> ?parameter?.
Hi,
So in the report you are drilling to, you have a query expression that is in the form [Package].[Dimension].[Hierarchy] -> ?Parameter? - can you confirm this?
What is being passed in the drill-through definition defined in the source report? A data item value or a parameter?
MF.
Yes, we are using same query expression and passing the paramater for drill through.
actually in the level1 there is no drillings, but we have drillings in level2.
Quote from: prasad23 on 20 Feb 2014 11:52:40 PM
Yes, we are using same query expression and passing the paramater for drill through.
Ok. What happens if you pass the data item value?
Quote from: prasad23 on 20 Feb 2014 11:52:40 PM
actually in the level1 there is no drillings, but we have drillings in level2.
Sorry - I can't make any sense of this. Can you explain what you mean? I thought you were passing a parameter based on a hierarchy, not on a level?
MF.
hi ,
1) if i pass the data item value from the source report then it is re prompts for target report, even we select the hierarchy.
but if i pass the parameter value it re prompts, when we select the only low level in tree prompt .
we are passing only parameters based on hierarchy for drill through in level1.
2) here level1 means source report and level2 target report.
in level 1 we have only one chart, it contains drill throughs
but in level2 we created charts as well as cross tab.
a) for charts we enable the drill up and drill down (level2)
b) cross tab contains drill throughs for level 3 (here level2 is source and level3 is target)
Hi,
Sorry - I'm getting very confused here. Let's see if we can make this simple (and if I understand correctly).
1. You have a source report with a tree prompt. This is driving something in the source report (crosstab/chart) to display selected members from the hierarchy? What report object is being affected by this prompt in the source report? What expression are you using to do this in the source report?
2. You are drilling through to a target report using a drill-through definition. It's not clear what you have defined this on in the source report. Is it the members you derived using the tree prompt?
3. In the target report, you have an item with an expression that would result in a tree prompt if you were not passing a parameter to it (so the expression is [Hierarchy] -> ?Param?)? What object is this included in - a crosstab/chart/list?
4. In the drill-through definition defined in the source report you are passing the parameter from the tree prompt in the source report?
Do I have this correct? Can you answer the pieces in there that we don't know?
You also mentioned that you have enabled drill-down in the target report. Does this impact anything or is it just for information? If it does have an impact, what and how?
In an earlier post you mentioned that in your layout calculation in the target report you had coded the expression ParamDisplayValue(?Param?). What results do you get if you use ParamValue(?Param?)
In the same post you also mentioned using an expression rootMember([namespce].[dimens].[hierarchy]) - why are you using this? Where are you using this? How is it related to the tree prompt or the report object in the target report? Or is it in the source report?
Cheers!
MF.
Hi MFGF,
We have similar issue with cognos 10.2
Recently we Migrated our reports from the Cognos 8.4 to Cognos 10.2. The Drill throughs in the migrated reports which are working fine in cognos 8.4 is not working as expected in cognos 10.2
We have source report with tree prompt. We are using this tree prompt to show selected items in the chart .we are drilling through to a target report using a drill-through definition.In the target report we have an Detail filter on query with expression that would result in tree prompt.
In drill through definition we are passing parameter value to the target reports parameter. Well this worked fine in the 8.4 but in 10.2 target report is re prompting for the value
Thanks in advance