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

Manage Excel Upload on Content Store

Started by sdf, 09 Apr 2020 09:17:08 AM

Previous topic - Next topic

sdf

For versions 11.0.4 and up the excel upload is automatically stored in the content store.
Question is, is there a way to query the content store to get details of the uploaded excel.
Due to large number of users using the upload feature, we need a way to monitor the size of the content store.

dougp

As an alternative, you can open IBM Cognos Configuration, go to Local Configuration > Environment and set the Data files location property to the file system location where you want to store the uploads.  It gets them out of the database, but just moves the storage problem from one place to another.

Either way, you should be able to query the Content store to get things like owner, last modified, location, name, etc.  The query would be the same as if you were looking for reports or packages.

sdf

Have you tried doing that?
As far as i know, version 11.0.5 forward, the uploaded data will be stored in the content store by default.
You can only change this if you use an external data store. In which case is different than the usual ../data/ folder.
Although, this ../data/ folder is now used as temp location to cache data from uploaded files and or data sets while using them.