70-467 · Question #100
You need to ensure that the Sales Per Capita calculated measure produces correct results. What should you do?
The correct answer is B. Set the Source DataType property of the Population measure to Biglnt. In SSAS, the Source DataType property of a measure controls how the engine reads raw data from the source - setting it to BigInt ensures large integer population values are not truncated during division in the per capita calculation.
Question
You need to ensure that the Sales Per Capita calculated measure produces correct results. What should you do?
Options
- ASet the DataType property of the Population column of the FactPopulation data source
- BSet the Source DataType property of the Population measure to Biglnt.
- CSet the data type of the Population column of the FactPopulation data warehouse table to
- DSet the DataType property of the Population measure to Biglnt.
How the community answered
(48 responses)- A15% (7)
- B75% (36)
- C6% (3)
- D4% (2)
Why each option
In SSAS, the Source DataType property of a measure controls how the engine reads raw data from the source - setting it to BigInt ensures large integer population values are not truncated during division in the per capita calculation.
The DataType property on the column in the data source view does not directly govern how SSAS reads the measure's source values - the measure's own Source DataType property takes precedence.
The Source DataType property on an SSAS measure tells the Analysis Services engine how to interpret the raw column data from the underlying source. If the Population measure's Source DataType is set to a smaller integer type, large values can overflow or be truncated before the division occurs in the Sales Per Capita expression. Setting Source DataType to BigInt ensures the full precision of the population values is preserved during measure evaluation.
Changing the physical data warehouse column type is an ETL/database layer change and does not by itself correct how SSAS interprets or processes the measure's data type within the cube.
The DataType property of the measure controls the output format returned to clients, not how source data is read; it is the Source DataType that determines how incoming data is interpreted by the engine.
Concept tested: SSAS measure Source DataType property configuration
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/define-measures-in-a-measure-group
Topics
Community Discussion
No community discussion yet for this question.