Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Tabular data
- Thread starter goldbloom
- Start date
Yes,
Try these links:
C'mon people; this is a forum for professionals!
soi la, soi carré
Try these links:
C'mon people; this is a forum for professionals!
soi la, soi carré
misscognos
Programmer
tabular model: an object used when you just want to create a query dragging in things from hte model. in crn, there are different objects that you can put into a query (slightly different gui and terminology in cognos 8). tabular model is one of them.. the "lowest level" if you will.
tabular sql: if you don't want to use the/a model, you can write your own sql.
tabular set: if you want to union, intersect except two or more queries. you can put tabular models into the children of the tabular set. or you can put in another tabular set. or even tabular sql. all depends on how you want to union, intersect, except.
tabular data: functionality to let you test queries at various levels. you can run the tabular data for a tabular model. whatever is selected will be run. so, a more complex example: you have a tabular set wtih left and right tabular model chilren. if you find that your report doesn't work and suspect it is due the something in the query and you want to pinpoint where its breaking, you can run the tabular data for the left tabular child, the right tabular child. if they run successfully, run it for the tabular set. it may fail due to for example a difference in the number of data items in each child tabular model.
tabular sql: if you don't want to use the/a model, you can write your own sql.
tabular set: if you want to union, intersect except two or more queries. you can put tabular models into the children of the tabular set. or you can put in another tabular set. or even tabular sql. all depends on how you want to union, intersect, except.
tabular data: functionality to let you test queries at various levels. you can run the tabular data for a tabular model. whatever is selected will be run. so, a more complex example: you have a tabular set wtih left and right tabular model chilren. if you find that your report doesn't work and suspect it is due the something in the query and you want to pinpoint where its breaking, you can run the tabular data for the left tabular child, the right tabular child. if they run successfully, run it for the tabular set. it may fail due to for example a difference in the number of data items in each child tabular model.
- Status
Similar threads
- Locked
- Question