Recent content by ShawnEvans

Hello, Thanks for the reply to my problem. I'm actually not using Impromptu, however I do believe your answer will set me straight. I'm strictly using Architect to create the data models, and then using these models as the base for the Cubes in transformer. I half suspected I would have to...

Hello, I've been having a problem with a number of the tables in my datawarehouse. The warehouse I'm working with has a star structure, which means I have a bunch of dimensions and a single fact table relating them. A few of my dimensions are referenced multiple times in the fact table...

Dagwood, I had similar needs on a project using Impromptu where data was being exported from an online query tool to a CSV file. To get the data into impromptu the easiest way I found was to open the CSV in Excel and save it as a DbaseV file format. Because Dbase is a database program...

Hello, I'm trying to determine how to create a cube from Transformer that is linked to an Oracle DB and is dynamically updated as the underlying DB information changes. Meaning, I don't want to have to update a cube every time the DB changes. I would rather have a single cube, accessed by...

Hello, I'm trying to put together a test environment to work with the latest Cognos business intelligence suite. During the install process I was prompted with the yes/no option of allowing Cognos Installer to make changes to the Active Directory schema. If you click 'no' the install process...

hello, I am trying to run Cognos PowerPlay transformer and establish a connection to an Oracle datasource. Seemed simple enough, until I realized that Cognos has a new found dependency on an Active Directory Server. I don't have access to an active directory server and don't have access to an...