I have a metric like this
Apply simple ("Case when #0=#1 then #2 else #3 end", Metric A, Prompt 1, metric B, Metric C)
Metric B = (Metric 1-Metric 2)/ Metric 2
Metric C = (Metric 3-Metric 4 )/ Metric 4
Both metric B and c are created as smart metrics
I Can successfully use these metrics in a regular report
But I want to use it in a Report services document
(cannot use grid in document for this purpose (Business doesn't want it in a grid))
when I import the report wit all metric in to the dataset
The applysimple metric is missing
what can I do to solve this issue
thanks
atul
Apply simple ("Case when #0=#1 then #2 else #3 end", Metric A, Prompt 1, metric B, Metric C)
Metric B = (Metric 1-Metric 2)/ Metric 2
Metric C = (Metric 3-Metric 4 )/ Metric 4
Both metric B and c are created as smart metrics
I Can successfully use these metrics in a regular report
But I want to use it in a Report services document
(cannot use grid in document for this purpose (Business doesn't want it in a grid))
when I import the report wit all metric in to the dataset
The applysimple metric is missing
what can I do to solve this issue
thanks
atul