Investigate Reports
Investigate Reports
Hi,
I am new to QualityStage, So i just started learning by using the IBM QualityStage Tutorial and dsx with the given csv file.
I ran Investigate job which does investigation on Name, Geographical details (City, Stage, Zip, etc.). Job has run successfully and it has created 3 csv reports.
So I want to see the same in IIS reports. I tried creating a report in IIS and ran but it is not outputting any data.
It just says Error! No data available or invalid data collection parameter.
Can some one advise how to see the reports?
I am new to QualityStage, So i just started learning by using the IBM QualityStage Tutorial and dsx with the given csv file.
I ran Investigate job which does investigation on Name, Geographical details (City, Stage, Zip, etc.). Job has run successfully and it has created 3 csv reports.
So I want to see the same in IIS reports. I tried creating a report in IIS and ran but it is not outputting any data.
It just says Error! No data available or invalid data collection parameter.
Can some one advise how to see the reports?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Which particular report did you try to create, of the templates that are provided? Did you actually run the report?
To be honest, and without checking, I'm not sure that Investigation outputs are available through the reports mechanism. Look at the available report templates to verify this (certainly what I said is true in version 8.5).
To be honest, and without checking, I'm not sure that Investigation outputs are available through the reports mechanism. Look at the available report templates to verify this (certainly what I said is true in version 8.5).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 44
- Joined: Wed Sep 02, 2015 7:19 am
- Location: Brasilia, Brazil
Im just having the same problem now, can someone help me?
Further information, i designed a job like this:
Oracle Connector------->Investigate------->Sequential file
Writing into a txt file.
write mode set to overwrite.
Write method set to specific files
clean on fail true
column names true(as mentioned here https://www.ibm.com/developerworks/comm ... 0013974225)
reject mode continue
comma delimmiter
double quotes
Doing a discrete investigate.
SQA reports are working fine...
Here a sample of my file:
"qsInvColumnName","qsInvPattern","qsInvSample","qsInvCount","qsInvPercent"
"CPF","nnnnnnnnnnn","00006713041","7,59500000000000000E+03","1,0000000E+02"
"TELEFONE_CELULAR","n","0","5,97000000000000000E+02","7,8604345E+00"
"TELEFONE_CELULAR","nnnn","8142","1,00000000000000000E+00","1,3166557E-02"
"TELEFONE_CELULAR","nnnnnnn","3847487","1,00000000000000000E+00","1,3166557E-02"
"TELEFONE_CELULAR","nnnnnnnn","11942022","6,99600000000000000E+03","9,2113235E+01"
but when i execute the report i got the same "invalid data collection parameter"
Further information, i designed a job like this:
Oracle Connector------->Investigate------->Sequential file
Writing into a txt file.
write mode set to overwrite.
Write method set to specific files
clean on fail true
column names true(as mentioned here https://www.ibm.com/developerworks/comm ... 0013974225)
reject mode continue
comma delimmiter
double quotes
Doing a discrete investigate.
SQA reports are working fine...
Here a sample of my file:
"qsInvColumnName","qsInvPattern","qsInvSample","qsInvCount","qsInvPercent"
"CPF","nnnnnnnnnnn","00006713041","7,59500000000000000E+03","1,0000000E+02"
"TELEFONE_CELULAR","n","0","5,97000000000000000E+02","7,8604345E+00"
"TELEFONE_CELULAR","nnnn","8142","1,00000000000000000E+00","1,3166557E-02"
"TELEFONE_CELULAR","nnnnnnn","3847487","1,00000000000000000E+00","1,3166557E-02"
"TELEFONE_CELULAR","nnnnnnnn","11942022","6,99600000000000000E+03","9,2113235E+01"
but when i execute the report i got the same "invalid data collection parameter"
Leandro Vieira
Data Expert - Brasilia, Brazil
Data Expert - Brasilia, Brazil
-
- Participant
- Posts: 44
- Joined: Wed Sep 02, 2015 7:19 am
- Location: Brasilia, Brazil
Thank you very much rjdickson, it was a locale problem, we are using PT_BR NLS, so decimal separators are comma separated, i changed the file separators mannualy and the report worked just fine.
But this opens another question, there is a way to change IIS NLS Settings?So i dont need to change every file and because im also having problems on doing any operation on my Information Analyzer project, and i think this is for the same reason, our database runs on PT-BR NLS too, and all analysis(columns, keys, etc) output as error.
But anyway thanks again for the help. :D
But this opens another question, there is a way to change IIS NLS Settings?So i dont need to change every file and because im also having problems on doing any operation on my Information Analyzer project, and i think this is for the same reason, our database runs on PT-BR NLS too, and all analysis(columns, keys, etc) output as error.
But anyway thanks again for the help. :D
Leandro Vieira
Data Expert - Brasilia, Brazil
Data Expert - Brasilia, Brazil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You should be able to change NLS default settings system-wide using the DataStage and QualityStage Administrator client, selecting the NLS button on the General page.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 44
- Joined: Wed Sep 02, 2015 7:19 am
- Location: Brasilia, Brazil