Recent content by stanielson

You use Cognos Web Services to accomplish this task.

There is a lot of functionality in the Decision Stream product. I would suggest you read Ralph Kimball's Data Warehouse Toolkit book to understand how the tool is used to build data warehouses.

Tip 1. Use fact builds (a.k.a. databuild) to stage your data. Tip 2. Use a naming standard so you make sense of your Decision Streams databuilds Tip 3. Write your SQL outside of Decision Stream then use the fact build wizard since it does mapping for you Tip 4. Save often. Tip 5. Go to...

Build your cube for multiple flat files instead of using one IQD. Every dimension should have its own flat file that only contains data for its dimension. Then create on transactional query that has to facts and the lowest level of every dimension. Also, be sure you set the lowest level of each...

Has anyone had any luck using the Trusted Signon Plugin or used the REMOTE_USER CGI variable to authenticate users on Unix

You could always use Portfolio that ships with Cognos.

vijayleads - send me an email at stanrich@swbell.net and we can setup a time to walk you through this via NetMeeting.

Justin, Any chance I could talk you into speaking about your migration to Series 7 at our Cognos User Group meeting on June 12th. We will be featuring George Town Universities implementation of Cognos PowerPlay and Impromptu via WebEx and would like hear from someone who has installed Series 7...

My company specializes in building Data Warehouses using Cognos Decision Stream. As a whole this is a good product. It was developed around Ralph Kimball's star schema methodology. It has a nice feature for handling surrogate keys and Type II slowly changing dimensions. Stan

Cognos has an API that has many objects exposed, however, if you're wanting to automate the modeling of a cube using Transformer you'll have to use the Model Definition Language (MDL) and Cognos Script or Visual Basic

Are you using IQD's to build in your Transformer model?

You should be able be able to use a prompt for both the provider id and the customer id. I could show via the web if you have Windows XP or Netmeeting or via WebEx if you interested.

You might need to add some indexes to your tables and check the SQL that Impromptu is sending to your database enginge to determine whether or not your join logic needs to be optimized. Stan

Can you give us more information. When you are referring to a new page are you talking about a web page?

You only need to publish the MDC files to Upfront. The PYI and MDL files are the model definition language of the MDC file in binary and ascii format respectively. You can write a simple ftp batch file and schedule the copy via the NT AT command. Or, if you have the UNIX version of PowerPlay you...