Search results for query: *

I've just installed Transformer V7.3 on a new workstation and copied a COGNOS.INI file from a workstation that was running V7.2 and V7.3. When I try to create a new model, Transformer gives the error: Transformer can't read the databsae [DCPICPRD] defined in (path). Any help getting past...

I'm trying to develop a Star Schema that is compatible with both DB2 and SQL Server. One of the biggest hurdles is dates. The DB2 date() function will convert an integer into a date, similarly the days() function will convert a date into the number of days since 01/01/0001. Does similar...

According to this site: http://www.functionx.com/sql/Lesson05.htm It would appear that UDB uses the same syntax as does C. A ^ B XOR A & B AND A | B OR etc....

>> Some rows showed 0.0, others showed -0.0, I doubt that COGNOS is 1's complement, so a rounding error sounds likely.

You could use EXECUTE IMMEDIATE.

I've run 4.3 on p6x0 series equipment, but not the 650 specifically. Still, I believe that it will run on that system.

An IDENTITY will be somewhat more efficient, but you probably won't notice the difference. Several things to consider here: * Your tools should match each other. Either get a better/newer modelling tool and use IDENTITY, or use the your trigger on your current modeller. * If you plan to...

The 192.168.1.1 address sounds like the Windows default address that it uses when it can't obtain a real one. This suggests that DHCP is not running on your local network. Kent

Check to make sure that the Directway device is really a router. It may be nothing more than special purpose switch (like a cable modem) that will communicate with only one device on the "private" side. If so, you'll need to install your own router behind the Direcway device. Kent

Which Linux distribution are you using?

Since this is a linux forum, I'll assume that Server2 is running linux of some sort. You should be able to turn on port-forwarding and have the server also act as a switch/router. The exact process varies a bit between distributions. Be careful! If you enable port forwarding within this...

I have several years worth of data in my Star Schema. The data is daily snapshots. What I'm hoping to do, is deliver a cube to my user base that allows them to use the COGNOS provided Time dimension (or a similar feel) to generate their reports. User A wants a report that shows the business...

>>why don't you defined your measures to be First or Last for the Period, and get the sum for the none time dimensions. The measure isn't the first day or last day of the month. In our environment, critical time periods begin/end with the onset of hurricane season, a hurricane being name...

We use Cognos cubes for a number of applications. One of them has proven quite difficult to implement because we need the time dimension to treat data differently than the Cognos provided implementation. This model doesn't care about "daily events" like sales, revenue, expenses. It does care...