| Date: | Fri, 7 Jan 2005 05:12:56 -0800 |
|---|
| Reply-To: | ct <carstentopp@WEB.DE> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | ct <carstentopp@WEB.DE> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | different statistics in the elements of computed columns |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Hello,
here is a problem about working with computed columns in a mddb.
I generate a mddb with analysis variables with different statistics
i.e.
proc mddb data = sashelp.prdsale
out=bsc.prdsale_kum ;
var actual / sum ;
var predict / max;
class prodtype product year quarter month;
hierarchy prodtype product / name ='Produkt' display= YES;
run;
Then I define in the metabase a computed column with the formula
actual/predict*100
The report in the OLAP Viewer show only missing values im the computed
column, because the statistics of the formelelemnts are different.
If I try to solve the problem with a skeleton (HOLAP) in an analog way,
an ERROR Window appears.
How can I handle a computed column with elements, that got different
statistics?
Carsten
| 
