Create the cube with suitable dimension and fact tables based on OLAP

ITVoyagers-BI-PRACTICAL-3-b-MU-TYIT

2 thoughts on “Create the cube with suitable dimension and fact tables based on OLAP”

  1. Hello,
    I am trying to follow the steps given, but during deployment I am getting following erroes and warning.Can you please help me.
    Warning1 Dimension [Dim Product] : Create hierarchies in non-parent child dimensions.

    Warning2 Hierarchy [Dim Date].[Hierarchy] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance.

    Warning3 Dimension [Dim Date] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies.

    Warning4 Database [cube_1] : The database has no Time dimension. Consider creating one.
    Error5 Internal error: The operation terminated unsuccessfully.

    Error6 The datasource, ‘Sales DW’, contains an ImpersonationMode that is not supported for processing operations.

    Error7 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Sales DW’, Name of ‘Sales DW’.

    Error8 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Dim Product’, Name of ‘Dim Product’ was being processed.

    Error9 Errors in the OLAP storage engine: An error occurred while the ‘Product Name’ attribute of the ‘Dim Product’ dimension from the ‘cube_1’ database was being processed.

    Error10 Server: The current operation was cancelled because another operation in the transaction failed.

    Reply

Leave a Comment