Need Help

[dhanu_today]

Hi All,

I have the fields like ID,IDSTARTDATE,PRODUCT,IDOPENDATE.

I have to count the ID's which are having the product as CASA in particular month.  E.g. March14.(IDSTARTDATE)

secondly i have to count the ID'S which are in IDSTARTDATE(March 14) for the PRODUCT CASA and which are having FD in next month

i.e(IDOPENDATE  April14)

The same above mentioned output is also attached with sample data.I have tried with e() and p() functions but stuck some where.

Let me know if in case of any details required.

Thanks in adv,

Dhanu

[dhanu_today]

Any hint from anyone...

[arthur_dom]

FD Is WHAT? forecast Date?

[arthur_dom]

ah i found on second sheet o xls

[dhanu_today]

FD is the PRODUCT....In the secondary i have count the ID's which are having in the IDSTARTDATE(in March) as well as having PRODUCT FD IN April(IDSTARTDATE).

OUTPUT:
ID	CASA	CASA+FD	CA	SA
100	1	1	YES	YES
101	1	0	YES	YES
109	1	1	YES	YES

Let me know any thing req.

Thanks,

Dhanu

[arthur_dom]

Se attached QVW, if it helps you.

[dhanu_today]

Thanks Arthur..Its helpful....Any chance to develop the same in front end using set analysis.Because all the fields are

coming from different tables in original data model and to reduce complexity at data model..

[arthur_dom]

Well... It is... you can create the monthopen_1 in calendar dimension. Or you could try to develop the application in different levels (1 to extract the data, 1 to treat the data  -storing in qvd files, and 1 to show data) in this way it's easier to develop.

If you don't have a calendar dimension to do this, it will be far more complicated, but possible...