February 8, 2011 at 4:13 am
Hi All
Earliear we have done using views. this is working fine for me.
We are trying to create wiht out view... like i have create one fact table which is showing measures... those columns are keep it in fact table.
Table : factUserTable (This table doesnt have any data)
Another main table which is avaible data from using this table i am creatin Dimensions from this table.
Now i have create cube after creation of dimnsions.
I have execute the cube but i am getting error.
Error:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_tbInventory, Column: InventoryID, Value: 1. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Fact Part Inventory ID of Dimension: Inventory from Database: PartsInventory, Cube: PartsInventory, Measure Group: Tb Inventory, Partition: Tb Inventory, 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 'Tb Inventory' partition of the 'Tb Inventory' measure group for the 'PartsInventory' cube from the PartsInventory database.
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.
Can we create the cube which is using fact table wiht out data ?
or we need any data in fact table.. Please let me know.
Please help me. if you have any link please give me that link
My mail id : pkkrao@gmail.com
Example:
I have three table one is fact table and another is two dimension table.....
1. Table1(Fact table) this doesnt have any data
These below two table are data available
2. Table2
3. Table3
using this
How to create a cube.Please send me the link are example or solution.//
Thanks ,
Regards,
Venu
February 13, 2011 at 2:18 pm
Hi
What do you mean, fact table does not contain data.. The error means when parsing the fact-table no corresponding PK was found in the dimension for the given FK in the fact-table.
I do not now what you are doing, it seems you associated the wrong facts to your design..
You can design, build and process a cube with an empty fact table without any problems.
You can design and build your dimension with empty dimension tables/sources..
You cannot process the [measures] facts partitions without having the dimensions filled/processed first. For every dimension key in a fact table there should be a corresponding key in the dimension first...
However you could set the error-handling in such way, errors are skipped
Be more clear, what you describe contradicts.
Regards Kees
March 12, 2011 at 3:25 am
Hi Kees,
I am new to Analysis Services and experiencing the same problem too so would appreciate your help.
When I use an actual table for my fact table (measures) there's no issues and the cube is processed with no problems. But as soon as I use a view, I get no data in my cube even though 1. there's data in the dimensions 2. I can browse and see the data in the fact table in the schema tab of cube editor (btw, I am using Analysis Services 2000) 3. the processing of the cube is successful (the return message you get after processing).
Did I miss a step? Should also note also the same screen in point 3 which says "Processing completed successfully" also states "Rows processed:0"
Appreciate any assistance.
Sam
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply