2 thoughts on “Create the cube with suitable dimension and fact tables based on OLAP”
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.
Hello,
This errors are due to version difference according to me as I have also faced same problems.
Kindly try to uninstall VS 2017 or whatever version installed also uninstall SQL Server 2012
And install only single software ie SQl 2012 full version
Steps for installation are provided in my previous post kindly follow them using following link: https://itvoyagers.in/2019/02/17/how-to-install-sql-server-2012-full-version-sqlserver2012sp1-fullslipstream-enu-x86/
This has SSDT inbuilt and there is no need for any other software to be installed.
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.
Hello,
This errors are due to version difference according to me as I have also faced same problems.
Kindly try to uninstall VS 2017 or whatever version installed also uninstall SQL Server 2012
And install only single software ie SQl 2012 full version
Steps for installation are provided in my previous post kindly follow them using following link:
https://itvoyagers.in/2019/02/17/how-to-install-sql-server-2012-full-version-sqlserver2012sp1-fullslipstream-enu-x86/
This has SSDT inbuilt and there is no need for any other software to be installed.
Thank you,
Team ITVoyagers.