Date: Tue, 19 Feb 2002 00:00:50 -0800
Reply-To: Vladimir <vladimip@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Vladimir <vladimip@YAHOO.COM>
Subject: 2 questions about EIS/OLAP functionality.
Content-Type: text/plain; charset=ISO-8859-1
I have the following questions:
The first one is:
I've buit the fact table with the following information:
Month (value in crossing)
Balance Article: 1 2 3 4 ...
1 100 98 99 102
2 50 52 51 ...
3 71 73 71 ...
But for solving task a customer don't neeed absolute values, it needs
difference of values and difference in percents (the table could be
rotated, if this help). As I see predefenied possibility of SAS
statistic allows me to calculate difference, percents only between 2
(two) rows or columns.
Some balance articles (from first example) have subarticles,
sub-subarticles ... and at last the balance account. A good task to
show SAS drill-downs and expand features.
1 1.1 1.1.1 1520 $15200
1 1.1 1.1.2 1530 $30300
Others (balance articles) don't have subarticles (only balance
3 . . 1610 $8000
Is it possible to hide not existing levels in the report of EIS/OLAP
and expend article 3 (from the example) to 1610 without interim
(missing or repeating) levels? The colleage of mine shows me this
functionality in BAAN-OLAP. And he solves my problems with 2-3-mouse
clicking. Is it possible to solve 2 my questions in SAS?