0

I was able to deploy a large cube (with 2 dimensions and 1 measure) in Analysis services server but only after setting configuration error options for both dimensions and the measure (through the properties dialog box of each one of them) to specify :

  1. KeyNotFound : IgnoreError &
  2. NullKeyNotAllowed : IgnoreError &
  3. NullKeyConvertedToUnknown : ReportAndContinue &
  4. CalculationError : IgnoreError

My problem is now after setting the right dimension usage options and after adding an admin access, still when i try to browse the cube the measure returns no values (adding the dimensions as well to browse changes nothing). The cube processing task ends succesfully after mentioning the number of measure rows read in the partition, also the table views data explorer for the measure returns the data correctly. My question is how to make the cube browsing return the measure rows when i execute the sample query provided by VS2019 ? PS : the measure i defined has the float type.

Hints : when i specify for the measure property KeyNotFound : ReportAndContinue the processing of cube stops with error message

saying reached limit number of errors

Thanks for the help.

UPDATE : FULL ERROR WHEN I PROCESS THE CUBE (translated from foreign language)

Errors in the OLAP storage engine: Attribute key not found during processing of: Table: 'dbo_MyFacttable', Column: 'Field7', Value: '7811'; Table: 'dbo_MyFacttable', Column: 'Champ14', Value: '3.64000'. The attribute is 'Field1'. Errors in the OLAP storage engine: The record was skipped because the attribute key could not be found. Attribute: Field1 of the dimension: Customer Address of the database: MyDB, Cube: Mycube, Group of measures: Facts, Partition: Facts, Record: 1. Errors in the OLAP storage engine: The processing operation is is complete because the number of errors that occurred during the operation has reached the error limit. Errors in the OLAP storage engine: An error occurred while processing the 'Facts' partition of the 'Facts' measure group for the 'Mycube' cube from the MyDB database.

18
  • So what are the errors you get in cube processing? Commented Aug 5, 2021 at 15:26
  • the error is reached limit number of errors when reading partition of the measures group it is an error occuring while the measure group rows are being read Commented Aug 5, 2021 at 15:53
  • That message says that there were other errors. Post those. Commented Aug 5, 2021 at 15:55
  • pls see my UPDATE, i had to cover name of the database as welle as the name of the cube Commented Aug 5, 2021 at 16:05
  • Also when i specify at the dimensions properties, UnknownMember to be Visible (for both dimensions i define) and KeyNotFound : IgnoreError at the measure level of my cube, the error disappears and the cube deploys but then when browsing the cube only the total of the measure value will show independently of any specified dimension Commented Aug 5, 2021 at 16:28

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.