I am trying to create a report in Cognos where most of the report is textual, and I  want to automatize it and  to show a several values using singletons. One query calculation is like: if (DateItem is >0) then ('increasing')  else ('decreasing'). The problem occurs when I am using several these calculations with other Members (but Year always), so the singleton returns the value from the first calculation for all the others. I was trying with Solve Order, but it was the same.

Then I used Repeater, which for the first calculation worked correct, but for the next one returned the same value for the Repeater1.

I know that creating new Query for every new singleton will solve problem, but since I have a lot of  these calculations and already several queries, that is not so viable option for me.

Any suggestion will be helpful.

Thanks

------------------------------
Veljko
------------------------------

Hi Veljko,

the Singleton is not the appropriate data container for your approach if you have individual data queries as it does not support "Master-detail-relationships" which would be mandatory for the Repeater to compute the right value at each iteration.

If you can't compute all values in one query, I suggest to use the crosstab or list data container, link them with Master-detail-relationships to your main query and drop all classes from the objects there and/or set rows/columns/corner to Box type = None. The crosstab will then look like plain text.

Here's a repeater that repeats a table with Singletons and a crosstab:

------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------

Thank you it works great, even without Master detail.

------------------------------
Veljko
------------------------------

Original Message:
Sent: Mon June 12, 2023 11:24 AM
From: Robert Dostal
Subject: Problem with multiple singletons or repeaters

Hi Veljko,

the Singleton is not the appropriate data container for your approach if you have individual data queries as it does not support "Master-detail-relationships" which would be mandatory for the Repeater to compute the right value at each iteration.

If you can't compute all values in one query, I suggest to use the crosstab or list data container, link them with Master-detail-relationships to your main query and drop all classes from the objects there and/or set rows/columns/corner to Box type = None. The crosstab will then look like plain text.

Here's a repeater that repeats a table with Singletons and a crosstab:

------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------