Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem in Drill through different hierarchies

Status
Not open for further replies.

liorw

Programmer
Jan 22, 2013
1
Hi,

I'm facing a problem when i try to pass a data by drill through between two reports.
The data i'm trying to pass is a date, that in the first report is connected to one Date Dimension, and on the other one it's connected to a different Date Dimension. The Dimensions are hierarchical.
I set a drill through from the first one by chosing to drill the date as "Data item" and tried already to pass the member uniqe name, the member caption and the business key. However, i get the same problem about the new hierarchical dimension is not recognizing the date.
How can i pass a the Data itself that the new report will find the Data in the new hierarchy ??

for example :
[Package name][Time_Dimension1][year]--> 2012
[Package name][Time_Dimension2][year]--> 2012

i want the second one the use the 2012 data to filter the new report

thanks for your help :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top