Virtual Cubes

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  October 26, 2006 at 10:05 am

  #170849

  I am having trouble making a virtual cube. I was wondering if someone could help. I want to validate a Sales fact. I have a sales fact (Validator) which is just the fact containing the Bill customer and another Sales Fact (Production) that is a star scheme. I am trying to do a virtual cube joined on the Bill customer

  I can not seem to get the dimensions to join.

  I can only get values for the source dimension. How do I make the system join it correctly. example below

  Bill Customer Validator Validator Amt Production Amt

  111 100 0

  Bill Customer Production Validator Amt Production Amt

  111 0 100

• October 30, 2006 at 8:00 am

  This was removed by the editor as SPAM

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  November 7, 2006 at 4:27 pm

  #670431

  Is there anyone out there that has virtual cube experiance?

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  November 7, 2006 at 4:27 pm

  #670430

  Is there anyone out there that has virtual cube experiance?