COGNOiSe.com - The IBM Cognos Community

Hi,

Can anyone tell me what is the use of Tabular Reference. I can use that only with a query. I can't put a tabular model and a reference at the query level. I can put that inside a tabular model. That is both become child elements of tabular model. If i do this the report doesnot validates as the source qualifier for the tabular reference elements are not valid. I can't use the tabular reference in tabular sets also.

I am really not able to understand where the hell this is used.

srik

Hi srik,

The idea of a tabular reference is that you can create a report with multiple queries (2, say), and instead of each query having it's own tabular model, you could reuse your work from one query in the other query.

For example, if you wanted the same data to be presented in both list and crosstab format within your report, you would need 2 queries.  If you needed to define a really complex calculation within this process, rather than having to define it twice (once for each tabular model), you could define it just once in the tabular model of your first query, then your second query could reuse the contents of your first query via a tabular reference.

Best regards,

MF.

Hi,

I am attaching here a small document..by this u can get, how table referance can be used..

Bye
Prem.

Hi

Thanks for the helpful information , but can I get another ( easy) example to explain the use of a tabular reference

BYE  :D

Tabular reference is a (easy answer here) a shortcut to another tabular model.

If you have 2 list reports an they each have the same information but presented a bit differently you would just create a Tabular Reference to the tabular model in one list. This will allow you to change one tabular model instead of 2 since one is just a shortcut to the other.

thanks for giving me the idea of the use of tabular reference.

One thing always stuck me..If i have two query q1 and q2 and q2 has a tabular reference to q1, and when i execute the report, will both the queries be fired on to the database or q1 would only be fired and the resultant is used even in q2.

Srik