Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    24

    Unanswered: Local cube creation -ErrMsg Fact Table not found

    Hi chaps,

    I am trying to create a local cube ,populating data from an oracle database.

    I have checked the connection part of the string.. Its working fine.

    The problem is -- it throws an error msg-- Fact Table not found...

    Dim strCreateCube As String
    Dim sSourceDSN As String
    Dim sInsertInto As String
    Dim adocon As New ADODB.Connection
    Dim sLocation As String
    sLocation = "LOCATION=C:\CubeOracle.cub"
    strCreateCube = ""
    strCreateCube = strCreateCube & "CREATECUBE= CREATE CUBE MYCUB " & vbCrLf
    strCreateCube = strCreateCube & " (" & vbCrLf
    strCreateCube = strCreateCube & " DIMENSION Product," & vbCrLf
    strCreateCube = strCreateCube & " LEVEL [Product Family]" & vbCrLf
    strCreateCube = strCreateCube & ")"
    sInsertInto = ""
    sInsertInto = sInsertInto & "INSERTINTO=INSERT INTO MYCUB" & vbCrLf
    sInsertInto = sInsertInto & " (" & vbCrLf
    sInsertInto = sInsertInto & " Product.[Product Family]" & vbCrLf
    sInsertInto = sInsertInto & " )" & vbCrLf
    sInsertInto = sInsertInto & " SELECT " & vbCrLf
    sInsertInto = sInsertInto & " sales_fact_1997.[Product:Product Family]" & vbCrLf
    sInsertInto = sInsertInto & " FROM sales_fact_1997" & vbCrLf
    sInsertInto = sInsertInto & " WHERE sales_fact_1997.[Time:year]='1997'"

    stSourceDSN = """Provider=MSOLAP;" & _
    "Data Source=qspl_quantlink;" & _
    "User ID=scott;" & _
    "Password=tiger"""

    sSourceDSN = "SOURCE_DSN=" & stSourceDSN

    strConnection = sLocation & ";" & vbCrLf & sSourceDSN & ";" & vbCrLf & strCreateCube & ";" & vbCrLf & sInsertInto

    MsgBox strConnection
    Set cn = New ADODB.Connection
    cn.Provider = "MSOLAP"
    cn.Open strConnection

    MsgBox "Cube created!"
    adocon.Close

    ProcExit:
    Exit Sub
    ProcErr:
    MsgBox Err.Number & Err.Description & Err.Source


    Could u pls tell me what is the problem.. Do I need to create a fact table physically in the oracle database and realate it to the other dimension tables or what else do I need to check.

    Thnx
    Loydon

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What does you question have to do with Oracle?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •