Hi members,
could some help me and explain why i am getting this kind of error. My cube executes successfully with errors.
Thanx
Ronald
Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_Prescription' table or view. The Source property may not have been set.
See my reply to your previous post.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
I'm getting the following error back when trying to process in a new measure group into an existing cube in 2005...
"Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_view_FACT_CPR_Hours' table or view. The Source property may not have been set."
I'm in the process of migrating my 2000 objects to 2005. I've basically copied over the 2000 relational db over to a 2005 SQL server and am going through and recreating the cubes from scratch. I was having this problem with another fact table and was able to remedy by creating a named query rather then hitting the view directly (even though the named query pulled the view straight). This hasn't worked for all of the tables giving me problems though. I know it's not a permission issue because I can hit some, but not all the tables. The bizarre thing is, I can browse the data in the dsv so I know it is recognizing the datasource, it just isn't recognizing it in the cube.
When I try to go to the partition tab in the cube builder it throws an "object block not set" error and crashes, or just crashes so I'm pretty sure it has something to do with this.
Is anyone else experiencing this problem? Help!
It looks like Analysis Services cannot find a DSV table 'dbo_view_FACT_CPR_Hours' . One of Analysis Services objects is based on this table.
It is very possible you can query tables in DSV and see the data, but if one of the dimension attributes references old table or a view, you will get error like one you are seeing above.
There is nothing much you can do, but carefully go through the cube desing and clean problem after problem. What can help you is: Try and create XMLA script for your database and then search for a 'dbo_view_FACT_CPR_Hours' table. This way you should be able to find an error faster.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
That's the problem though, there is a 'dbo_view_FACT_CPR_Hours' table in the dsv. I can't understand why AS can't find it when processing the cube. I built the measure group in the cube referencing it that source in the dsv. The cube will process fine without that measure group but as soon as I add it in again and try to process it bombs.
I'll continue to investigate the code on my end. I'll let you know if I come up with something.
Thanks for your help.
I'm getting an error when processing a partition - Errors in the high-level relational engine. The table_name table that is required for a join cannot be reached based on the relationships in the data source view.
This table is actually joined to another dimension table, which is then joined to the fact table.
How can I resolve this error?
I did notice that there are no keys in the dimension table that relate to the fact table for this particular table. Is this a data issue?|||Well, that might be the reason... To be honest I can't imagine a business case where you have a dimension table without any link to a fact table... Perhaps you can help me to understand you issue...|||Usually I find that missing dimension key issue when there is corruption in the data. My underlying view was actually pointed to the wrong database - I corrected that but surprisingly it still didn't fix the problem.
Interestingly enough, the previous AS 2000 database used the 'name' column as a key for some of the dimensions. In AS 2000 this was acceptable as long as they were unique. AS 2005 doesn't like that so much. So I went through each dimension & changed it's key column to the proper key.
I am still troubleshooting for some other dimensions. I think it has something to do with the datatype being bigint instead of double in a dimension key. I am finding this to be a very tedious and time-consuming process.
If there's any way of visuallizing the two queries side-by-side to compare dimension/fact table keys that may help me.
Also, are there any resources on how to best hook up a dimension that has a related dimension but no fact table key. (eg Dimension Group links to Dimension links to Fact)?
|||Andrew,
you can define a snowflake schema (Dimension Group links to Dimension links to Fact). You simply define more than one table in your dimension...
I think SSAS 2005 is more restrictive when it comes to keys. And yes, I think it's good. It takes some time to get used to it but a good design helps you much in this case... And having a name as a key is everything but best practice...
Having a double as a key is also not best practice... It's much better to have int/bigint at this point...
You can also switch on the build-in "unknown member" support... It's much better to do that on your own in the ETL process but i.e. if you set your cube directly on top of a productive system it might be helpful...
|||Good tips. thanks! I am just trying to get it processing successfully, so the double/bigint switch will be something to try afterwards. The dimension/fact table key data should line up and there is a big problem when every record has unknown dimension members.
Let's hope that processing 21m rows in the dimension today is faster than yesterday.
Hi all,,
Could someone help me out and explain to me why my two fact tables process successfully but the process still fails when i try to process the cube.
This is the detailed error message.
Ronald
<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">
<Object>
<DatabaseID>FirstCube</DatabaseID>
<CubeID>MSCPROJECT</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Cube 'MSCPROJECT' completed successfully.
Start time: 6/20/2006 1:52:34 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:01
Processing Measure Group 'Patient Diagnosis' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Processing Partition 'Patient Diagnosis' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Processing Measure Group 'Prescription' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Processing Partition 'Prescription' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Errors and Warnings from Response
Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_Prescription' table or view. The Source property may not have been set.
Errors in the OLAP storage engine: An error occurred while processing the 'Prescription' partition of the 'Prescription' measure group for the 'MSCPROJECT' cube from the FirstCube database.
Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
Errors in the OLAP storage engine: An error occurred while processing the 'Patient Diagnosis' partition of the 'Patient Diagnosis' measure group for the 'MSCPROJECT' cube from the FirstCube database.
Check your DSV - data source view.
Looks like your DSV is missing 'dbo_Prescription' table.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Edward,
It looks like as if I have dbo_Prescription table in my data source View.
I will check it out tomorrow morning and i will get back to you.
Thank you for your time.
Ronald
|||Hi Edward, In my data source view i have the dbo.Prescription table not dbo_Prescription.
Do these namings really matter.
Ronald
|||The naming is really important. Without you specifying names correctly Analysis Server has no idea how to construct a valid SQL query.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Edward,
In My data source view, I have the dbo.Prescription table. You know dbo.Prescription and dbo.PatientDiagnosis are my fact tables. I have failed to understand this since i have these two tables in my data source view.
Please help out.
Is this connected with SQL SERVER 2005 service pack1.
Ronald
Below is the same error i get when i process the cube.
<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">
<Object>
<DatabaseID>Analysis Services Project1</DatabaseID>
<CubeID>MSCPROJECT</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Dimension 'Initial Visit' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'Physician Id' completed successfully. 8 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_InitialVisit].[PhysicianId] AS [dbo_InitialVisitPhysicianId0_0]
FROM [dbo].[InitialVisit] AS [dbo_InitialVisit]
Processing Dimension Attribute 'Nurse ID' completed successfully. 7 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_InitialVisit].[NurseID] AS [dbo_InitialVisitNurseID0_0]
FROM [dbo].[InitialVisit] AS [dbo_InitialVisit]
Processing Dimension Attribute 'Initial Visit' completed successfully. 51 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_InitialVisit].[PatientId] AS [dbo_InitialVisitPatientId0_0],[dbo_InitialVisit].[Date] AS [dbo_InitialVisitDate0_1],[dbo_InitialVisit].[PhysicianId] AS [dbo_InitialVisitPhysicianId0_2],[dbo_InitialVisit].[NurseID] AS [dbo_InitialVisitNurseID0_3]
FROM [dbo].[InitialVisit] AS [dbo_InitialVisit]
Processing Dimension 'Project' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'Project Name' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Project].[ProjectName] AS [dbo_ProjectProjectName0_0]
FROM [dbo].[Project] AS [dbo_Project]
Processing Dimension Attribute 'Project' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Project].[ProjectId] AS [dbo_ProjectProjectId0_0],[dbo_Project].[ProjectName] AS [dbo_ProjectProjectName0_1]
FROM [dbo].[Project] AS [dbo_Project]
Processing Dimension 'Medicine Type' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'Name' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicineType].[Name] AS [dbo_MedicineTypeName0_0]
FROM [dbo].[MedicineType] AS [dbo_MedicineType]
Processing Dimension Attribute 'Medicine Type' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicineType].[MedicineTypeCode] AS [dbo_MedicineTypeMedicineTypeCode0_0],[dbo_MedicineType].[Name] AS [dbo_MedicineTypeName0_1]
FROM [dbo].[MedicineType] AS [dbo_MedicineType]
Processing Dimension 'Patient' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'DateOfBirth' completed successfully. 49 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Patient].[DateOfBirth] AS [dbo_PatientDateOfBirth0_0]
FROM [dbo].[Patient] AS [dbo_Patient]
Processing Dimension Attribute 'Gender' completed successfully. 3 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Patient].[Gender] AS [dbo_PatientGender0_0]
FROM [dbo].[Patient] AS [dbo_Patient]
Processing Dimension Attribute 'PatientId' completed successfully. 50 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Patient].[PatientId] AS [dbo_PatientPatientId0_0],[dbo_Patient].[DateOfBirth] AS [dbo_PatientDateOfBirth0_1],[dbo_Patient].[Gender] AS [dbo_PatientGender0_2]
FROM [dbo].[Patient] AS [dbo_Patient]
Processing Hierarchy 'PatientId - DateOfBirth - Gender' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension 'Diagnosis' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Diagnosis Name' completed successfully. 5 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Diagnosis].[Diagnosis name] AS [dbo_DiagnosisDiagnosis_x0020_name0_0]
FROM [dbo].[Diagnosis] AS [dbo_Diagnosis]
Processing Dimension Attribute 'Description' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Diagnosis].[Description] AS [dbo_DiagnosisDescription0_0]
FROM [dbo].[Diagnosis] AS [dbo_Diagnosis]
Processing Dimension Attribute 'Diagnosis' completed successfully. 5 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Diagnosis].[DiagnosisCode] AS [dbo_DiagnosisDiagnosisCode0_0],[dbo_Diagnosis].[Diagnosis name] AS [dbo_DiagnosisDiagnosis_x0020_name0_1],[dbo_Diagnosis].[Description] AS [dbo_DiagnosisDescription0_2]
FROM [dbo].[Diagnosis] AS [dbo_Diagnosis]
Processing Dimension 'Medical Provider' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Name' completed successfully. 15 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[Name] AS [dbo_MedicalProviderName0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Gender' completed successfully. 3 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[Gender] AS [dbo_MedicalProviderGender0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Indicator Nurseor Physician' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[IndicatorNurseorPhysician] AS [dbo_MedicalProviderIndicatorNurseorPhysician0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Physician Id' completed successfully. 9 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[PhysicianId] AS [dbo_MedicalProviderPhysicianId0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Nurse Id' completed successfully. 9 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[NurseId] AS [dbo_MedicalProviderNurseId0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Medical Provider' completed successfully. 15 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[MedicalProviderId] AS [dbo_MedicalProviderMedicalProviderId0_0],[dbo_MedicalProvider].[Name] AS [dbo_MedicalProviderName0_1],[dbo_MedicalProvider].[Gender] AS [dbo_MedicalProviderGender0_2],[dbo_MedicalProvider].[IndicatorNurseorPhysician] AS [dbo_MedicalProviderIndicatorNurseorPhysician0_3],[dbo_MedicalProvider].[PhysicianId] AS [dbo_MedicalProviderPhysicianId0_4],[dbo_MedicalProvider].[NurseId] AS [dbo_MedicalProviderNurseId0_5]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension 'Allergy' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Allergy Name' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Allergy].[AllergyName] AS [dbo_AllergyAllergyName0_0]
FROM [dbo].[Allergy] AS [dbo_Allergy]
Processing Dimension Attribute 'Allergy' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Allergy].[AllergyCode] AS [dbo_AllergyAllergyCode0_0],[dbo_Allergy].[AllergyName] AS [dbo_AllergyAllergyName0_1]
FROM [dbo].[Allergy] AS [dbo_Allergy]
Processing Dimension 'Medicine' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Name' completed successfully. 19 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Medicine].[Name] AS [dbo_MedicineName0_0]
FROM [dbo].[Medicine] AS [dbo_Medicine]
Processing Dimension Attribute 'Medicine' completed successfully. 20 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Medicine].[MedicineCode] AS [dbo_MedicineMedicineCode0_0],[dbo_Medicine].[Name] AS [dbo_MedicineName0_1]
FROM [dbo].[Medicine] AS [dbo_Medicine]
Processing Dimension 'Services' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute 'Service Title' completed successfully. 36 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Services].[Service_Title] AS [dbo_ServicesService_Title0_0]
FROM [dbo].[Services] AS [dbo_Services]
Processing Dimension Attribute 'Service Order' completed successfully. 18 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Services].[Service_Order] AS [dbo_ServicesService_Order0_0]
FROM [dbo].[Services] AS [dbo_Services]
Processing Dimension Attribute 'Services' completed successfully. 36 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Services].[ServiceId] AS [dbo_ServicesServiceId0_0],[dbo_Services].[Service_Title] AS [dbo_ServicesService_Title0_1],[dbo_Services].[Service_Order] AS [dbo_ServicesService_Order0_2]
FROM [dbo].[Services] AS [dbo_Services]
Processing Dimension 'Return Visit' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
Processing Dimension Attribute 'Physician Id' completed successfully. 8 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[PhysicianId] AS [dbo_ReturnVisitPhysicianId0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Nurse Id' completed successfully. 9 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[NurseId] AS [dbo_ReturnVisitNurseId0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Time Start' completed successfully. 11 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[TimeStart] AS [dbo_ReturnVisitTimeStart0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Time End' completed successfully. 22 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[TimeEnd] AS [dbo_ReturnVisitTimeEnd0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Return Visit' completed successfully. 50 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[PatientId] AS [dbo_ReturnVisitPatientId0_0],[dbo_ReturnVisit].[Date] AS [dbo_ReturnVisitDate0_1],[dbo_ReturnVisit].[PhysicianId] AS [dbo_ReturnVisitPhysicianId0_2],[dbo_ReturnVisit].[NurseId] AS [dbo_ReturnVisitNurseId0_3],[dbo_ReturnVisit].[TimeStart] AS [dbo_ReturnVisitTimeStart0_4],[dbo_ReturnVisit].[TimeEnd] AS [dbo_ReturnVisitTimeEnd0_5]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension 'Severity' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
Processing Dimension Attribute 'Severity Name' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Severity].[SeverityName] AS [dbo_SeveritySeverityName0_0]
FROM [dbo].[Severity] AS [dbo_Severity]
Processing Dimension Attribute 'Severity' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Severity].[SeverityCode] AS [dbo_SeveritySeverityCode0_0],[dbo_Severity].[SeverityName] AS [dbo_SeveritySeverityName0_1]
FROM [dbo].[Severity] AS [dbo_Severity]
Processing Cube 'MSCPROJECT' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Measure Group 'Patient Diagnosis' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Partition 'Patient Diagnosis' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Measure Group 'Prescription' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Partition 'Prescription' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Errors and Warnings from Response
Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_Prescription' table or view. The Source property may not have been set.
Errors in the OLAP storage engine: An error occurred while processing the 'Prescription' partition of the 'Prescription' measure group for the 'MSCPROJECT' cube from the Analysis Services Project1 database.
Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
Errors in the OLAP storage engine: An error occurred while processing the 'Patient Diagnosis' partition of the 'Patient Diagnosis' measure group for the 'MSCPROJECT' cube from the Analysis Services Project1 database.
