If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Test a report without accesss to data source

Started by bladeless, 03 Sep 2018 07:39:31 AM

Previous topic - Next topic

bladeless

Hello All,

Is it possible to test a report if I dont have accesss to data souce of the package that is used by the report?
Can you tell me please how to do it?

sdf

I believe no.
The connection between the package and the data source must be established in creating/executing reports.

You can explain your current situation, what you have/ don't have, how are you doing things and what are your expected output. There must be something we can work around.

bladeless

I would like to test new report. But I don't have access to data source of the report. DB server is offline now.
Of course I can wait until the DB come back online.
But I thought if it is possible to test without the connection to the datasource then better to test the report instead of waiting ...

sdf

what kind of test are you aiming?

Theoretically, you cannot runt the report if the datasource connection of the package is not established.
The package alone does not store actual data. It has the metadata and the structure. When you run the report, it will base the data structure to your model and then will connect to the database using the database connection specified in the admin. Therefore, your report will not fetch any data.

If you have an available copy of the datasource you can specify in your package to use that. That will work if all the objects exists in that db. Other than that, I'm not sure if it would work if you have a prior report output/saved version.


Francis aka khayman

you can change the connection to connect to another datasource like in DEV.... just to test...

...unless you are trying to do something fishy