Drill through issues in virtual cubes

  • The customers currently have a requirement that combine seperate database with similar data and want a single view of the data. Although the data is similiar the fields sizes and names are not. I built four individual cubes that when combined the users would have all the required information. I built the virtual cube which worked correctly but the drill through aspects never worked for all of the cubes that were combine. The drill through doesn't fail it just brings up a blank spread sheet with column headers from some of the linked cubes. If I only combine two of the cubes to make a virtual one, the drill through worked correctly. Any idea's on what I am doing wrong, or what can be done to correct the problem

  • This was removed by the editor as SPAM

  • Do you have all the dimensions that you need in all the four cubes?

  • Yes!  I do have all the dimensions defined.   I am just not able to to link the 4 cubes together and get a virtual cube with Drill through working with all of the dimensions correctly.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply