Cube Deploy to Another Server

Use SFTP login with no password. Follow instructions in this link:

http://www.jscape.com/blog/setting-up-sftp-public-key-authentication-command-line

Creating Durable Models

One big advantage using durable Framework Manager model is that any change you make in the model will not have any effect on reports using that model (at least in theory). For example, should you change the name of a Query Item from "Company" to "Companies", after publishing, any report using this query model will still work fine (at least in theory). 

To create durable FM models, follow these steps:

1. Click on Project -> Languages -> Define Languages

2. Add another language preferably the same as what you are currently using. Example if your current Language is English, you can choose to add English (Malta).

3. Set this language as your Active Language.

4. Click ok

5. Click your Project in Project Viewer.

6. Set the Use Design Locale for Reference ID to True

7. Save

This should make your FM model durable.

Please not as of this time, I have not yet tested this process thoroughly. Hopefully I will be able to do so soon when I am not so busy anymore.

Free Disk Space 2

Another directory to look at if you find you are running out of disk space is the bin folder in your Cognos server installation.

Cognos will usually huge core dump files and save it in the bin directory. For windows the files will have a <process id>.dmp filename while in Linux the file will have core.<process id> filename.

I found several in my server and they consume nearly 20GB in disk space.

Hide an Object (Object Level Security)

At times, hiding an object to users is required. For example, only managers should have access to a certain table. Using data level security/filtering can still prevent viewing the data, but the users can still see the object.

To add object level security, select the object from Framework Manager, open Actions from Menu, and choose Specify Object Security. A pop up window will appear where the object security can be edited.

There are things one need to consider however when using object level security. The first is that when you add object level security, everyone is denied access to the object EVEN SYSTEM ADMINISTRATORS. Those who have access to the objects needs to be explicitly specified.

In this example below, I denied the System Administrators access to table Table2 and gave Everyone access to Table 1.

In Report Studio, even a System Administrator will not be able to access Table2.



Please note that if a user belongs to more than 1 role or group, and one of those groups are denied access, the user WILL BE DENIED ACCESS as well. All the groups the user belongs to should have access for a user to gain access to an object with object level security. For any conflicting security access, the deny access will have priority.