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>
Organization: http://groups.google.com/
Subject:      2 questions about EIS/OLAP functionality.
Content-Type: text/plain; charset=ISO-8859-1

Hello,

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.

2.
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.
                                     Values
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
accounts).

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?

Tnank you.
Vladimir