Solved

Saving Reports locally in Cognos

Posted on 2011-09-14
4
1,445 Views
Last Modified: 2012-05-12
I need to set up the cognos environment to save the reports locally. I have googled it and found some info regarding the same and I even tried it. but, unfortunately it is giving this error- "Automation server can't create object. unable to display the local file system because the file LFA.dll isn't registered, or the security settings do not allow it."

The steps which I followed are:
Steps
Obtain the LFA.dll from your IBM Cognos 8 administrator.

The DLL is located in the bin directory where IBM Cognos 8 is installed.

Open a command prompt window.

Register the LFA.dll file by typing the following:

regsvr32 LFA.dll

In Internet Explorer, set your computer and the IBM Cognos 8 server as trusted sites:

From the Tools menu, click Internet Options.

On the Security tab, click Trusted sites.

Click Sites.

Clear the Require server verification (https:) for all sites in this zone check box.

In the Add this Web site to the zone box, type http://localhost and click Add.

Tip: If the IBM Cognos 8 server is not on the same computer as the browser, type http://<computer name> instead.


Repeat the above step for http://<IBM Cognos 8 servername>.

In Report Studio, from the Tools menu, click Options.

Click the Advanced tab.

Select the Allow local file access check box and click OK.

The menu items (Local) Open and (Local) Save As appear in the File menu.

Close and restart Report Studio.

You can now open and save reports on your computer. The first time you try to open or save a report locally, Internet Explorer asks you whether you want to allow an ActiveX control on the page to interact with other parts of the page. Click Yes to continue.

Any help is really appreciated.

Thanks
0
Comment
Question by:pashi_26
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
SNeupane earned 50 total points
ID: 36538749
I'm not sure why you are going through all this.
You can simply add the directory where you want to save the report to your Cognos configuration under 'Actions>Edit Global Configuration>Archive Location File System Root'.
For example: file://D:\Cognos Report Outputs
This adds 'Save to the file system    Edit the options...' during report run with options.
Then you can either run the report or schedule to save outputs to that location.
0
 
LVL 8

Expert Comment

by:SNeupane
ID: 36538777
Refer to 'Installation and Configuration' guide (inst_cr_winux) for details.
Archive Location Property
In older versions of IBM® Cognos® BI, report output was saved by default in the content store. You
can now configure two additional save locations, one inside IBM Cognos BI and one outside IBM
Cognos BI. For more information, see "Saved Report Output" (p. 385).
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36967102
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question