Hello experts,
Here I have faced several issues in cognos 10.2. I need your help to recover it that is:
1) When I run client wise report it produce that data is correct but client name (member caption) as wrong like that data retrieved by our client not for selected filters.
2) Same issue happened my resource wise report too.
3) Filters is not working properly. for example create a report for yesterday activities it shown wrong results. I was cross checked that why said. Even I put that day like'2015-06-03' report studio generate "no data available".
Above issues were worked good. Here I attached my sample report again. Give some solution to overcome it. Thank you
Quote from: vignesvar on 04 Jun 2015 07:49:24 AM
Hello experts,
Here I have faced several issues in cognos 10.2. I need your help to recover it that is:
1) When I run client wise report it produce that data is correct but client name (member caption) as wrong like that data retrieved by our client not for selected filters.
2) Same issue happened my resource wise report too.
3) Filters is not working properly. for example create a report for yesterday activities it shown wrong results. I was cross checked that why said. Even I put that day like'2015-06-03' report studio generate "no data available".
Above issues were worked good. Here I attached my sample report again. Give some solution to overcome it. Thank you
Hi,
Unfortunately you're going to need to give us far more detail than this. All we can see from your attached document is that you are not getting the results you desire. We don't know how you have written your report, though. We don't know if you are using a relational or a dimensional package. We don't know how you are trying to filter the data.
Can you provide more detail?
MF.
Thank you for response MFGF,
I'm using Relational package. I got a correct results of filter but the problem is row caption getting wrong. There are two activities mainly used. Here both produce unexpected wrong result when I combine into single crosstab. If it is separate crosstab both are same and expected results. Major problem row caption went to wrong in crosstab. It was worked good early. There is no problem in filter. When I combine both activities into single crosstab I have repeated data thats why told filter is not work. .
Have a nice day
Quote from: vignesvar on 06 Jun 2015 02:12:33 AM
Thank you for response MFGF,
I'm using Relational package. I got a correct results of filter but the problem is row caption getting wrong. There are two activities mainly used. Here both produce unexpected wrong result when I combine into single crosstab. If it is separate crosstab both are same and expected results. Major problem row caption went to wrong in crosstab. It was worked good early. There is no problem in filter. When I combine both activities into single crosstab I have repeated data thats why told filter is not work. .
Have a nice day
Hi,
Ok - you're using a relational package. That's a good start. You claim that there is no problem with your filter, but then you also say you are getting data retrieved that is not for your selected filters. These two statements appear to be contradictory. You refer to combining two crosstabs, but you haven't told us what this entails. You haven't told us how your current filters are defined. Unless you give us details like this, it's impossible for any of us to begin to understand where your issue lies.
MF.
Thank you MF. I was correct it. Joining between the tables were wrong. Now it is working good. Have a nice day