How to create a calculated metric from a combined Dataset
I am trying to modify a report built on a Cube Data Source. The report calculates standard metrics, (Qty, $ales, etc). I need to modify the report to calculate a "rate" (Qty/Day, $ales/Day, etc). Since the SSRS 2008 region can address only 1 Dataset, I modified my MDX query to retrieve both the metrics and the count of Days. (Qty and $ales are passed to the query via a parameter). So my dataset for Qty now looks like this where CYTD=CurrentYearToDate, PY=PriorYear: CYTD_Act CYTD_Bdgt PY_Act PY_Bdgt Store1Qty 100 150 1050 1000 Store2Qty 150 200 1500 2000 Store3Qty 125 125 2200 2000 Store1Days 88 90 300 330 Store2Days 45 75 330 360 Store3Days 90 90 360 360 The "rate" metrics I am try to calculate will allow me to compare store performance and account for the varying number of days that the store was open. My report aggregates day and brings back the appropriate calculations comparing the various measures. I can filter the dataset to bring back either "StoreXQty" or "StoreXDays". My question is: How do create an expression in SSRS to calculate this "rate" based on my combined Dataset? StoreXQty/StoreXDays Appreciate any suggestions.
April 20th, 2011 10:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics