Home » Developer & Programmer » Data Integration » Business objects - little crosstable problem
Business objects - little crosstable problem [message #130608] Mon, 01 August 2005 08:03 Go to next message
barabasmihai
Messages: 2
Registered: August 2005
Junior Member
Hello.
I'm a newbie in Business Objects and I have a simple problem (first of many Mad ) but not also a solution. Who has a little of time and can help, please do so. I will start to describe the problem:

There are two tables:

Quarters Activities
ID Name Name Quarter_FK_ID
1 Q1 activity1 1
2 Q2 activity2 3
3 Q3 activity1 1
4 Q4

Hope it's clear enough, we have activity1 twice in the first quarter and activity2 once in the third quarter.

I have tried and tried to create a crosstable who looks like this

Q1 Q2 Q3 Q4
activity1 2 0 0 0
activity2 0 0 1 0

but without success. The closest solution I have found, was that I return a cross join between the two tables and as crosstable body a variable "=(If (<QuarterId>= <QuarterIdFK>) Then Count(<ActivityNr>) Else 0)", BUT, in this case, I obtained this:

Q1 Q2 Q3 Q4
activity1 1 0 0 0
activity1 1 0 0 0
activity2 0 0 1 0

Thanks in advance,
Mihai.
Re: Business objects - little crosstable problem [message #130610 is a reply to message #130608] Mon, 01 August 2005 08:08 Go to previous message
barabasmihai
Messages: 2
Registered: August 2005
Junior Member
I will "redraw" the tables, I saw that the spaces are not taken in consideration

Quarters------------------------------Activities
ID---Name-----------------------------Name--------Quarter_FK_ID
1----Q1-------------------------------activity1---1
2----Q2-------------------------------activity2---3
3----Q3-------------------------------activity1---1
4----Q4


I have tried and tried to create a crosstable who looks like this:

--------------Q1-----Q2-----Q3-----Q4
activity1-----2------0------0------0
activity2-----0------0------1------0
Previous Topic: datawarehouse structure
Next Topic: Teradata - Query error 3707
Goto Forum:
  


Current Time: Mon Jan 20 11:41:33 CST 2020