none
Cube Error :

    Question

  • Hi Team,

    I have a cube by the name Studnet attendence which evaluates the studence attendence (which have only one fact table calld Fact_Stu_Attendence).

    There is a relationship between Fact_Stu_Atten and Dim_ Sub department and also relationship exist between Fact_Stu_Atten and dim_Dept.When i am processing my cube it throwing me the following error:

    Error Message:

    <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
      <Parallel>
        <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
          <Object>
            <DatabaseID>New_Educational_Analytics</DatabaseID>
            <CubeID>Student_Attendence</CubeID>
          </Object>
          <Type>ProcessFull</Type>
          <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
        </Process>
      </Parallel>
    </Batch>
    Processing Dimension 'Dim Employee' completed.
    Start time: 9/30/2013 12:44:18 PM; End time: 9/30/2013 12:44:18 PM; Duration: 0:00:00
    Processing Dimension Attribute '(All)' completed.
    Start time: 9/30/2013 12:44:18 PM; End time: 9/30/2013 12:44:18 PM; Duration: 0:00:00
    Processing Dimension Attribute 'Dept Name' completed. 3 rows have been read.
    Start time: 9/30/2013 12:44:18 PM; End time: 9/30/2013 12:44:18 PM; Duration: 0:00:00
    SQL queries 1
    SELECT 
      DISTINCT
     [dbo_Dim_Dept].[Dept_ID] AS [dbo_Dim_DeptDept_ID0_0],[dbo_Dim_Dept].[Dept_Name] AS [dbo_Dim_DeptDept_Name0_1]
      FROM [dbo].[Dim_Dept] AS [dbo_Dim_Dept]
    Processing Dimension Attribute 'Emp Type' completed. 3 rows have been read.
    Start time: 9/30/2013 12:44:18 PM; End time: 9/30/2013 12:44:18 PM; Duration: 0:00:00
    SQL queries 1
    SELECT 
      DISTINCT
     [dbo_Dim_Employee].[Emp_Type] AS [dbo_Dim_EmployeeEmp_Type0_0]
      FROM [dbo].[Dim_Employee] AS [dbo_Dim_Employee]
    Processing Dimension Attribute 'Sub DeptName' completed.
    Start time: 9/30/2013 12:44:18 PM; End time: 9/30/2013 12:44:18 PM; Duration: 0:00:00
    Errors and Warnings from Response
    Internal error: The operation terminated unsuccessfully.
    Errors in the high-level relational engine. The 'dbo_Dim_Dept' table that is required for a join cannot be reached based on the relationships in the data source view.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Employee', Name of 'Dim Employee' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Sub DeptName' attribute of the 'Dim Employee' dimension from the 'New_Educational_Analytics' database was being processed.
    Server: The operation has been cancelled.

    Please help me out to solve this issue

    Thank in advance

    Monday, September 30, 2013 7:24 AM

Answers

  • NB515,

    Same answer as the other post: you seems to have attribute in the Employee dimension using the Dim_SubDept table but there is no link between Dim_Employee and Dim_SubDept in the DSV..

    • Marked as answer by NB515 Monday, September 30, 2013 11:08 AM
    Monday, September 30, 2013 10:46 AM

All replies

  • Hi NB515,

    If I understood correctly, your model is like this:

    Make sure that arrows go from your fact to your dimensions (and not the other way around).

    Cheers,

    Guillaume

    Monday, September 30, 2013 7:49 AM
  • You are right but instead of Employee i have sub department in the same way.

    as per your suggestion in my DSV every arrow is going from fact to dimension only still i am getting the same issue.what will be the reason for this?

    Monday, September 30, 2013 8:04 AM
  • NB515,

    Another problem that could cause that issue is when an attribute of your dimension is linked to another table than your dimension (and there is no link between those tables in your DSV):

    Check in the property pane that each attribute of your dimension use the same table.

    Cheers,

    Guillaume

    Monday, September 30, 2013 8:36 AM
  • Sorry i did not get you correctlt.can you please explain in more detalied way?
    Monday, September 30, 2013 9:21 AM
  • Yes, for example, if your create an Employee dimension based on the DimEmployee table but in that dimension you also have attribute with column (key, name or value) pointing to another table than the DimEmployee (e.g. DimDepartment).
    Monday, September 30, 2013 9:29 AM
  • Now i understood ur point.in my scenario dim_sub_department table is related with another table which is Dim_Dept.

    But when i am looking over at that particular key ,name or value column properties  they have setted to respective ID's and names.still is there any properties to set?

    Monday, September 30, 2013 10:08 AM
  • NB515,

    If your model is the same as below, you cannot use the Dim_SubDept table in your Dept dimension. You have to create 2 different dimensions.

    If you still want the use the Dim_SubDept table in your Dept dimension, then you need to update your model like this:
    (Create a FK in SubDept)

    If you want to avoid snowflaking, you can store Dept & SubDept in only one dimension table.

    Monday, September 30, 2013 10:18 AM
  • You can see my DSV picture in the below screen shot

    (In some dimension tables i have some related foreign keys but there is no relationshps between so please dont confuse with that part)

    Is everything is ok with my DSV?

    Monday, September 30, 2013 10:25 AM
  • For the Fact_Attendence, your DSV seems correct.

    Make sure that those foreign keys are always set (never null) - and that the related record exists.

    Have you tried to process dimension by dimension, instead of the whole cube in order to locate the error ?
    If yes, on which dimension does the error popup ?

    Monday, September 30, 2013 10:38 AM
  • NB515,

    Same answer as the other post: you seems to have attribute in the Employee dimension using the Dim_SubDept table but there is no link between Dim_Employee and Dim_SubDept in the DSV..

    • Marked as answer by NB515 Monday, September 30, 2013 11:08 AM
    Monday, September 30, 2013 10:46 AM