How would you help them in a way that is the least time consuming?

Some users need a new Critical Success Factor or Ratio based on a measure that is not available.
How would you help them in a way that is the least time consuming?

A.
Start looking in the source database(s) for base elements. Next step would be to check BTL if
these are already mapped and available in the warehouse. If not, build new ETL, register ETL and
new warehouse objects in DAC and model in BI repository. If available, build the new ratio in the
Business Model and Mapping Layer, set available in the presentation layer and test in Answers.

B.
Start looking for base elements in the physical layer in the repository. If available you can
directly build the ratio in the Business Model and Mapping Layer, set available for querying in the
presentation layer and test results in Answers. If not available, check the warehouse tables and
lastly the source tables.

C.
Directly start building SDE and SIL mappings to enhance the warehouse with extra columns.
Register the mappings and new warehouse objects in the DAC, run the ETL and model in the BI
repository. Test your work in Answers.

D.
Build a request in Answers based on the online BI Repository and create your new ratio as a
new column based on other columns.

E.
Build a request in Answers directly on the source data available to you and create the new ratio
as a new column in your report.