Olap cubes question

[Maguin, Eugene]

All,

The olap cubes output is stacked in layers (argh!). Question is whether
there is a way (no python or scripting) to unstack it? I looked in setup
panel (edit->options) but saw nothing obvious. The layering business is
supposed to be clever but I think it is stupid.

Thanks, Gene Maguin

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[ViAnn Beadle]

The "layering business" is the principal characteristic of OLAP cubes as
generally defined by folks in the Business Intelligence community--blame
them. If you are NOT using the CREATE subcommand, see if SUMMARIZE will meet
your needs.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Gene Maguin
Sent: Tuesday, September 07, 2010 9:03 AM
To: [hidden email]
Subject: Olap cubes question

All,

The olap cubes output is stacked in layers (argh!). Question is whether
there is a way (no python or scripting) to unstack it? I looked in setup
panel (edit->options) but saw nothing obvious. The layering business is
supposed to be clever but I think it is stupid.

Thanks, Gene Maguin

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

All,

Ok, Olap cubes has a different origin history and, it sounds like, is
tailored to the needs of somewhat specific group of users. I actually looked
at summarize, ctables, and means. I wanted output that flowed down the page,
as ctables does, and I wanted to see skew and kurtosis as well as means and
sds, which both means and summarize reports. Olap cubes came the closest of
any procedure.

Thanks, Gene Maguin


-----Original Message-----
From: ViAnn Beadle [mailto:[hidden email]]
Sent: Tuesday, September 07, 2010 3:36 PM
To: 'Gene Maguin'; [hidden email]
Subject: RE: Olap cubes question

The "layering business" is the principal characteristic of OLAP cubes as
generally defined by folks in the Business Intelligence community--blame
them. If you are NOT using the CREATE subcommand, see if SUMMARIZE will meet
your needs.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Bruce Weaver]

Gene Maguin wrote

All,

The olap cubes output is stacked in layers (argh!). Question is whether
there is a way (no python or scripting) to unstack it? I looked in setup
panel (edit->options) but saw nothing obvious. The layering business is
supposed to be clever but I think it is stupid.

Thanks, Gene Maguin

I don't know about the rest of you, but I didn't understand what Gene was describing, so I opened the General Social Survey data set, and ran this:

OLAP CUBES age educ paeduc maeduc speduc prestg80 BY sex
  /CELLS=COUNT MEAN STDDEV SKEW KURT
  /TITLE='OLAP Cubes'.

Now I understood.  The pivot table in the output showed results for the TOTAL only (i.e., both males and females combined).  In order to see results for males or females, I had to double click on the pivot table, and then select Males or Females from the drop-down list.  I agree with Gene that this is a pain in the backside.  

So Gene, why not just use OLAP CUBES, or even DESCRIPTIVES in conjunction with SPLIT FILE?  E.g.,

sort cases by sex.
split file by sex.
DESCRIPTIVES VARIABLES=age educ paeduc maeduc speduc prestg80
  /STATISTICS=MEAN STDDEV KURTOSIS SKEWNESS.
split file off.

And if stats for the Total are desired, run it again with the SPLIT FILE off.

Cheers,
Bruce

[Rick Oliver-3]

With the exception of computed category differences, MEANS will give you the same output as OLAP CUBES without collapsing the results into layers by default  (and without requiring SPLIT FILE, which also requires that the file be sorted by the split variables).

From:	Bruce Weaver <[hidden email]>
To:	[hidden email]
Date:	09/07/2010 04:01 PM
Subject:	Re: Olap cubes question
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Gene Maguin wrote:
>
> All,
>
> The olap cubes output is stacked in layers (argh!). Question is whether
> there is a way (no python or scripting) to unstack it? I looked in setup
> panel (edit->options) but saw nothing obvious. The layering business is
> supposed to be clever but I think it is stupid.
>
> Thanks, Gene Maguin
>
>

I don't know about the rest of you, but I didn't understand what Gene was
describing, so I opened the General Social Survey data set, and ran this:

OLAP CUBES age educ paeduc maeduc speduc prestg80 BY sex
 /CELLS=COUNT MEAN STDDEV SKEW KURT
 /TITLE='OLAP Cubes'.

Now I understood.  The pivot table in the output showed results for the
TOTAL only (i.e., both males and females combined).  In order to see results
for males or females, I had to double click on the pivot table, and then
select Males or Females from the drop-down list.  I agree with Gene that
this is a pain in the backside.

So Gene, why not just use OLAP CUBES, or even DESCRIPTIVES in conjunction
with SPLIT FILE?  E.g.,

sort cases by sex.
split file by sex.
DESCRIPTIVES VARIABLES=age educ paeduc maeduc speduc prestg80
 /STATISTICS=MEAN STDDEV KURTOSIS SKEWNESS.
split file off.

And if stats for the Total are desired, run it again with the SPLIT FILE
off.

Cheers,
Bruce


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Olap-cubes-question-tp2806236p2806901.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Bruce Weaver]

Rick Oliver wrote

With the exception of computed category differences, MEANS will give you
the same output as OLAP CUBES without collapsing the results into layers
by default  (and without requiring SPLIT FILE, which also requires that
the file be sorted by the split variables).

I agree that all the same numbers will be there, but the layout will be different.  OLAP CUBES and DESCRIPTIVES generate output that has one row per variable, with the requested statistics in columns.  MEANS generates output with one column per variable with the requested statistics in rows.  Therefore, if the number of variables is large, the table gets quite wide, which may not be convenient.  I interpreted Gene's "flowing downward" as meaning that he wanted the variables in the rows, and statistics in the columns.  But maybe I was wrong.

Cheers,
Bruce

[Rick Oliver-3]

Ah, that makes sense.

From:	Bruce Weaver <[hidden email]>
To:	[hidden email]
Date:	09/07/2010 04:43 PM
Subject:	Re: Olap cubes question
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Rick Oliver wrote:
>
> With the exception of computed category differences, MEANS will give you
> the same output as OLAP CUBES without collapsing the results into layers
> by default  (and without requiring SPLIT FILE, which also requires that
> the file be sorted by the split variables).
>
>

I agree that all the same numbers will be there, but the layout will be
different.  OLAP CUBES and DESCRIPTIVES generate output that has one row per
variable, with the requested statistics in columns.  MEANS generates output
with one column per variable with the requested statistics in rows.
Therefore, if the number of variables is large, the table gets quite wide,
which may not be convenient.  I interpreted Gene's "flowing downward" as
meaning that he wanted the variables in the rows, and statistics in the
columns.  But maybe I was wrong.

Cheers,
Bruce


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Olap-cubes-question-tp2806236p2806965.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[ViAnn Beadle]

This is a matter or initial layout and doesn't constrain any pivoting or
modification of pivots via the SPSSINC MODIFY TABLES procedure.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Bruce Weaver
Sent: Tuesday, September 07, 2010 3:41 PM
To: [hidden email]
Subject: Re: Olap cubes question

Rick Oliver wrote:
>
> With the exception of computed category differences, MEANS will give
> you the same output as OLAP CUBES without collapsing the results into
> layers by default  (and without requiring SPLIT FILE, which also
> requires that the file be sorted by the split variables).
>
>

I agree that all the same numbers will be there, but the layout will be
different.  OLAP CUBES and DESCRIPTIVES generate output that has one row per
variable, with the requested statistics in columns.  MEANS generates output
with one column per variable with the requested statistics in rows.
Therefore, if the number of variables is large, the table gets quite wide,
which may not be convenient.  I interpreted Gene's "flowing downward" as
meaning that he wanted the variables in the rows, and statistics in the
columns.  But maybe I was wrong.

Cheers,
Bruce


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Olap-cubes-question-tp2806236p
2806965.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command SIGNOFF SPSSX-L For a list of
commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon K Peck]

But bear in mind that tables can be easily transposed, either interactively or with the SPSSINC MODIFY TABLES extension command or the scripting apis directly.
Jon Peck
SPSS, an IBM Company
[hidden email]
312-651-3435

From:	Rick Oliver/Chicago/IBM@IBMUS
To:	[hidden email]
Date:	09/07/2010 04:24 PM
Subject:	Re: [SPSSX-L] Olap cubes question
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Ah, that makes sense.

From:	Bruce Weaver <[hidden email]>
To:	[hidden email]
Date:	09/07/2010 04:43 PM
Subject:	Re: Olap cubes question
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Rick Oliver wrote:
>
> With the exception of computed category differences, MEANS will give you
> the same output as OLAP CUBES without collapsing the results into layers
> by default  (and without requiring SPLIT FILE, which also requires that
> the file be sorted by the split variables).
>
>

I agree that all the same numbers will be there, but the layout will be
different.  OLAP CUBES and DESCRIPTIVES generate output that has one row per
variable, with the requested statistics in columns.  MEANS generates output
with one column per variable with the requested statistics in rows.
Therefore, if the number of variables is large, the table gets quite wide,
which may not be convenient.  I interpreted Gene's "flowing downward" as
meaning that he wanted the variables in the rows, and statistics in the
columns.  But maybe I was wrong.

Cheers,
Bruce


-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Olap-cubes-question-tp2806236p2806965.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD