If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

What kind of object use to present data

Started by Avisto.sbu, 25 Apr 2014 11:17:47 AM

Previous topic - Next topic

Avisto.sbu

Hello

I have a list of zones :z1,z2,z3
a list of terminals t1,t2,t3
and turnovers

I have to create a kind of table like the one below:







turnover year-1turnover yearturnover evolution
Total z1 with t1+t2
Total z1 with t3+t4
Total z1+z2 with t1+t3
.....

actually I have a random combination of terminal and zones to filter  :'(

what should I use for that a table, cross table, list?
and there are 12x9 columns like that  :'( should I create 108 different queries?

thanks in advance for your help

MFGF

Quote from: Avisto.sbu on 25 Apr 2014 11:17:47 AM
Hello

I have a list of zones :z1,z2,z3
a list of terminals t1,t2,t3
and turnovers

I have to create a kind of table like the one below:




Are you using a relational or dimensional model?

Is there any specific pattern to the rules of what appears in rows, or are they all manually defined?

MF.




turnover year-1turnover yearturnover evolution
Total z1 with t1+t2
Total z1 with t3+t4
Total z1+z2 with t1+t3
.....

actually I have a random combination of terminal and zones to filter  :'(

what should I use for that a table, cross table, list?
and there are 12x9 columns like that  :'( should I create 108 different queries?

thanks in advance for your help
[/td][/tr][/table]
Meep!