Hi Team,
I am quiet new to Cognos but I have developed few reports using cognos.I am facing a strange issue in cognos 10.1.
I have a report which i have developed using SQL which has been provided other team.This report has few columns ,in one of the column I will get an option to click on a link when I click on that link it will open a new window which will allow the user to enter some values and save it(write back to the database) those values will save in the data base.I am not sure how they have developed this SQL I just used the SQL in the report.
Now my problem is when I run my report using this SQL from Report studio its showing a message like "this page cant be displayed"(PFA from more information) but when i run the same report from Cognos connection this report is working fine i am getting exact output.(I am running correct report if i open it and try to run it from report studio its throwing an error)
So could you please help me in fixing this issue or at least could you please share your views.My client has been hammering me for a while because of this issue.I have attached the SQL which I am using (with name changes) and also the screen shot of the issue.
your help highly appreciated.
Regards
BI User
Hi Team,
Attaching error screen shot of the error.I have tried in all browsers.different user credentials, different machines still i am facing the issue.I am able to fire the same SQL in the DB using same credentials.I don't think its problem with Security.
Please share your view ASAP if possible.
Regards
BI User
Hello cognosbiuser,
Your screenshot suggests that the issue happens while validating the SQL. Can you tell us whats the property of the SQL that you have set, i.e. Native or Pass-through? If you are set as Native, set it as Pass-through and give it a try.
-Cognos810
It is insane to use Cognos with SQL like this. That is why you create proper models that can do this kind of aggregation for you.
Sorry congnosbiuser, I realize it is probably not your choice, but whoever is deciding this is how you should create a Cognos report needs to know they are totally wrong in using Cognos like this. I am almost willing to call them out as incompetent.
This kind of logic and aggregation belongs in an FM or cube model, not in pass-through SQL.
Hi BdBits/Cognos810,
Thanks a lot for your promt response.
Bdbits I understood your view.but some how still they want to use the SQL rather than using or updating FM model.I am unable controle it :(
Cognos810 I have tried changing it to pass through SQL Still I am getting same issue.any other inputs please.
Regards
Cognosbiuser
:o
I am totally with bdbits on this one, but I have to ask.....if it runs perfectly fine from Cognos Connection then why not just run it from Cognos Connection?