Can this be done in a crosstab?

building reports desktopintelligence
1

I have a Business Objects crosstab that looks like the following…

|— 1996 -----|— 1997 -----|— 1998 ----| Emp# Stat |APA 1/1/96 5.0| |
| |APA 1/1/97 3.0|
| | |BUD 3/1/98 1.0
|MA 1/1/96 3.9 | |
| |MA 1/1/97 6.0 |

PQ 2/2/98 7.0

What I would like to have is this…

|— 1996 -----|— 1997 -----|— 1998 ----| Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0 |--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish this and I’m open to suggestions on a totally new approach. Any comments would be appreciated. I’m using version 4.1

Listserv Archives (BOB member since 2002-06-25)

2

I have a Business Objects crosstab that looks like the following…

      |--- 1996 -----|--- 1997 -----|--- 1998 ----|

Emp# Stat |APA 1/1/96 5.0| |
| |APA 1/1/97 3.0|
| | |BUD 3/1/98 1.0
|MA 1/1/96 3.9 | |
| |MA 1/1/97 6.0 |
| | |PQ 2/2/98 7.0
|--------------|--------------|-------------|

What I would like to have is this…

      |--- 1996 -----|--- 1997 -----|--- 1998 ----|

Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0
|--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish this and I’m open to suggestions on a totally new approach. Any comments would be appreciated. I’m using version 4.1

Listserv Archives (BOB member since 2002-06-25)

3

One thing you can try, since crosstabs can’t contain dimension objects, create a new object based on the one in the body of the crosstab. Place in the formula =, then go back to the definition screen and change it from a dimension to a measure. Then substitute your new object into the body.

Hope that works!

Sue

What I would like to have is this…

|— 1996 -----|— 1997 -----|— 1998 ----| Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0 |--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish this and I’m open to suggestions on a totally new approach. Any comments would be appreciated. I’m using version 4.1

Listserv Archives (BOB member since 2002-06-25)

4

One thing you can try, since crosstabs can’t contain dimension objects,
create a new object based on the one in the body of the crosstab. Place in
the formula =, then go back to the definition screen and
change it from a dimension to a measure. Then substitute your new object
into the body.

Hope that works!

Sue

What I would like to have is this…

      |--- 1996 -----|--- 1997 -----|--- 1998 ----|

Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0
|--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish
this and I’m open to suggestions on a totally new approach. Any comments
would be appreciated. I’m using version 4.1

Listserv Archives (BOB member since 2002-06-25)

5

When you create the new object, if the measure doesn’t work with only the object as it’s formula, add an In statement to the formula:

e.g. = In (<Emp# Stat Object>, )

HTH!

What I would like to have is this…

|— 1996 -----|— 1997 -----|— 1998 ----| Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0 |--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish this and I’m open to suggestions on a totally new approach. Any comments would be appreciated. I’m using version 4.1

Listserv Archives (BOB member since 2002-06-25)

6

When you create the new object, if the measure doesn’t work with only the
object as it’s formula, add an In statement to the formula:

e.g. = In (<Emp# Stat Object>, )

HTH!

What I would like to have is this…

      |--- 1996 -----|--- 1997 -----|--- 1998 ----|

Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0
|--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish
this and I’m open to suggestions on a totally new approach. Any comments
would be appreciated. I’m using version 4.1

Listserv Archives (BOB member since 2002-06-25)

7

This can be done very easily: just put the max() or min() function inside the crosstab, then the rows with dimension emp# will automatically collaps.

Walter.

Cindy Clayton wrote:

I have a Business Objects crosstab that looks like the following…

|— 1996 -----|— 1997 -----|— 1998 ----| Emp# Stat |APA 1/1/96 5.0| |
| |APA 1/1/97 3.0|
| | |BUD 3/1/98 1.0
|MA 1/1/96 3.9 | |
| |MA 1/1/97 6.0 |

PQ 2/2/98 7.0

What I would like to have is this…

|— 1996 -----|— 1997 -----|— 1998 ----| Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0 |--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish this and I’m open to suggestions on a totally new approach. Any comments would be appreciated. I’m using version 4.1

–
Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria Tel. +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)

8

This can be done very easily: just put the max() or min() function inside the crosstab, then the rows with dimension emp# will automatically collaps.

Walter.

Cindy Clayton wrote:

I have a Business Objects crosstab that looks like the following…

      |--- 1996 -----|--- 1997 -----|--- 1998 ----|

Emp# Stat |APA 1/1/96 5.0| |
| |APA 1/1/97 3.0|
| | |BUD 3/1/98 1.0
|MA 1/1/96 3.9 | |
| |MA 1/1/97 6.0 |
| | |PQ 2/2/98 7.0
|--------------|--------------|-------------|

What I would like to have is this…

      |--- 1996 -----|--- 1997 -----|--- 1998 ----|

Emp# Stat |APA 1/1/96 5.0|APA 1/1/97 3.0|BUD 3/1/98 1.0
|MA 1/1/96 3.9 |MA 1/1/97 6.0 |PQ 2/2/98 7.0
|--------------|--------------|-------------|

I’ve come to the point where I realize that a crosstab can’t accomplish this and I’m open to suggestions on a totally new approach. Any comments would be appreciated. I’m using version 4.1

–
Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria
Tel. +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)