Problem in using remote db in ssas

  • hi !

    we have a server where all the DB's are stored in.

    in my local machine (xp pro) i do have SQL 2008 Express with advanced edition.

    i am trying out a SSAS project.

    i did successfully a project by using a db locally placed in my machine.

    But when i try to use a db being in that remote machine, i am not able to do it.

    its throwing many errors.

    is it not possible to use a remote db in local SSAS project..please say me....

    Thanks !

  • hi im getting the following error please help me..

    Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Good_x0020_Will_x0024_Purch__x0020_Inv__x0020_Line, Column: Item_x0020_Category_x0020_Code, Value: . Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Code of Dimension: Item Category from Database: SSAS_Cubes, Cube: PurchaseInv, Measure Group: Purch_ Inv_ Line, Partition: Purch_ Inv_ Line, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while processing the 'Purch_ Inv_ Line' partition of the 'Purch_ Inv_ Line' measure group for the 'PurchaseInv' cube from the SSAS_Cubes database.

  • hi Any help please !!!

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

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