Recent content by AnthonyMJ

The only thing I did was to change the {@Day1} to include the evaluateafter({@CreateArray}) and that did the trick. Thanks a lot for your help. XIR2 on Unix Solaris Informatica 7.1.3 CRXIR2, Oracle 9i/10g

I placed the reference formula at the right side of the CreateArray formula Here's how the report looks like :- Item Days CreateArray Day1 ----+-----------------------------------+-----------+-----------+ A 2009-01-10, 2009-01-15, 2009-02-14 True B...

Thanks. I have created the formula you suggested and it returned TRUE. Then, before I reference the array in other formulas, I just want to check and see day values in the dates array and my formula doesn't show anything. //{@Day1} global stringvar array dates; dates[1]; Also, changed the...

Tried that too..That didn't work. Still getting the same error. XIR2 on Unix Solaris Informatica 7.1.3 CRXIR2, Oracle 9i/10g

Sample Data Below Item Days ----+-----------------------------------+ A 2009-01-10, 2009-01-15, 2009-02-14 B C 2009-03-24, 2009-04-23 D 2009-05-20 As you can see, the Days column may not contain anything or may contain 3 Days or more. I would like to create an...

The challenge here is arriving at the resulting table. We need to check first for non-existency of dates for ES_DATE_H and CS_DATE_H in ES_DATE and CS_DATE respectively. Once we have completed this task, we can then apply the automated totalling in CR. Ideas ? XIR2 on Unix Solaris Informatica...

The resulting table should actually look like this in theory Resulting Table ES_DATE_H CS_DATE_H +---------+----------+ 04/21/09 11/30/08 08/30/09 11/01/09 The maximum date between the 2 columns is still 11/01/09. XIR2 on Unix Solaris Informatica 7.1.3 CRXIR2, Oracle 9i/10g

Data for a Group 1 ES_DATE ES_DATE_H CS_DATE CS_DATE_H +---------+---------+---------+---------+ 07/30/09 04/21/09 01/30/10 11/30/08 06/30/09 06/30/09 12/30/09 12/30/09 07/30/09 07/30/09 08/15/09 10/20/09 07/30/09 08/30/09 10/20/09 11/01/09 I would like to get the...

Can you just do the usual way of setting parameters in the universe? Something like this :- dbo.table1.YEAR >= @prompt('Year','D','List of Values Here',mono,constrained) XIR2 on Unix Solaris Informatica 7.1.3 CRXIR2, Oracle 9i/10g

Create a formula like this join({prompt name}, ', ') XIR2 on Unix Solaris Informatica 7.1.3 CRXIR2, Oracle 9i/10g

Thank you for the response. I have tried using running total but as you said, the result is somewhat different. The distinct count is actually going to be used to store the dates in an array. This array will be used to plot the dates on a manual gantt chart represented by icons (Size and...

I have table as below and would like to create a column that displays the distinct count of all the date columns and reset on change of Customer and Product Customer Product Date1 Date2 --------+-------+----------+----------+ ABC 123 01/01/08 02/15/08 ABC 123...

I have a report grouped on Customers (1) and then Products (2) and used printTime formulas (ie. WhilePrintingRecords) to calculate some metrics. All metrics are placed in both GF1 and GF2. One of the requirement is to display GF1 on top of GF2. Underlaying GF2 to GF1 doesn't work. Any help is...

I have succeeded in concatenating a list of products for the same customer. Now I would like to change the color of those products where the sale date is greater than a specified date. Here's a mockup data. Customer Product Sale Date --------+---------+----------- 1 A...

Thanks. The post helped. XIR2 on Unix Solaris Informatica 7.1.3 CRXIR2, Oracle 9i/10g