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 :
KeyNotFound : IgnoreError
&NullKeyNotAllowed : IgnoreError
&NullKeyConvertedToUnknown : ReportAndContinue
&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.
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