Capturing an event

building reports desktopintelligence
1

My requirement is little bit weird. I have a report scheduled for a particular time. Now there is one column (SAY ‘A’) which will retrieve data through free hand SQL. And in some other column (SAY ‘B’) I have a calculation using column ‘A’ values. Now the requirement is like, say one time values under column ‘A’ is 1,2,3…on second run if the values are same in Column ‘A’ i.e 1,2,3…then consider the values in the calculation else ignore it. Similarly on third run values could be different all together in column ‘A’ eg…123,345,6332…that time as well i should not use those values in the calculation because it has appeared for the first time. If the same values come on second run then again i need to consider it. In short any values that appears more than one time need to be considered every time. Is this a feasible thought in Desk I???

BO_User2000 (BOB member since 2008-11-18)

2

It sounds more like you’d have to do something within a database prior to running the scheduled report where you have “first time” flags and similar. Deski is a single pass tool and doesn’t retain historical data in the report; just the records of how the data provider previously performed are viewable from Data Manager.

3

Could you please explain it a bit more…

BO_User2000 (BOB member since 2008-11-18)

4

You’ll need to have extra columns in an underlying database to indicate the state of each code. Have a chat with a database or application developer within your company to explain what you want to do. It may end up as a stored procedure or data integrator job.