Search results for query: *

Then how could you be expected to know which records are on a Monday or which are on Tuesday? You will only know the month and year for each record, not each day. It would then be impossible to only show records on Monday.

You will need to make sure that your COGNOS joins are outer joins. You can check them by going to CATALOG / JOINS and selecting the relevant join, there are tick boxes to make them outer joins.

So your filter will have; Year = YEARPROMPT and Month = MONTHPROMPT and dayofweek(DATE) = 1 Where the DATE fieled in the dayofweek function is the date of the record. Do you have a date field for each record?

Just add a filter in the report that will return only mondays. add this to your existing filter. dayofweek(DATE) = 1 Where dayofweek is a function. And then sort the DATE field A - Z.

I have a cube that I need to create a 6 Week financial period in December. I know that Transformer has the ability to add an extra week, but if Dec is is already a 5 week period then the Cognos help tells me that it will make Nov a 5 week period, not Dec a 6 week period. I have created a...

Give this a go. UPDATE MyTable SET MyBitColumn = MyNumericColumn1 + MyNumericColumn2 WHERE MyNumericColumn1 + MyNumericColumn2 <> 0 and etc.... Brett

Why would you like to know how much it costs if you don't even know what it is??? Try www.microsoft.com/sql

I found the solution. To overcome the problem I needed to have 2 if-then statements. If (Total(Qty) <> 0 then Total(Sales) else 1) / (If Total(Qty) <> 0 then Total(Qty) else 0) The reason for the error in the first place was that the DB actually can perform the Sales/Qty calc. before the...

I have created a report that shows Sales, Quantity and Margin. Margin is created by Sales / Qty. I have totals at a couple of groupings, so Margin is the Total(Sales) / Total(Qty). In each Margin calculation I have used an if then statement. If Total(Qty <> 0) then Total(Sales) / Total(Qty)...

Have you tried to read the manual to get info on Prompts and Filters. It's very helpfull.

I'm not sure if I understand but would this work. Update Production set [Transaction Price] = (select [Costing Sum 1] from pricelist where [pricelist].[Company]=[production].[Company] and [pricelist].[Facility]=[production].[Facility] and [pricelist].[Item number]=[production].[Component...

Couple of basic things to check. -You need to have a copy of the catalog saved in the same directory as the reports. - The catalog needs to have the database login info saved. (Catalog / User Profiles / Database from Impromptu.)

Thanks guys, I had already started to work on the alias and this works fine. I'll have a go at overiding the SQL as well, though this is pretty restrictive if I then want to add any further data.

I have 1 catalog setup against our DataWarehouse and it is working well. I have recently been creating a few new reports and I have issues with the joins. With some reports I want to remove (or not use) a join that is needed for other reports. Apart from creating a copy of the catalog is there...

If T2 holds all of the new data then how about deleting from T1 where a record exists and then insert them from T2. Steps would be Delete from T1 where custnr exists in T2 Insert into T1 (Select * from T2) If T1 joins to other tables using a unique id and not the custnr then you would first...

What came of the project? Did you manage to come up with a good revenge fantasy and get the chage to live it? Hope that it worked out OK for you and that it didn't involve sleeping with CEO, unless that was your only option of course, was it fun :-) ? Brett

I've just had the same thing, we're running Transformer 7 on Win 2000. In traditional Microsoft fashion the first thing that I tried was a re-boot and all worked fine. Check out documents 109583 and 85779 on the Cognos Knowledge base. If you don't have access let me know. Basically they say; -...

If the two servers are on the same network then you should be able to open the package from the machine it is saved on then go to PACKAGE / SAVE AS, then change the Server Name to the new server. If it isn't in the drop down box then just type it in. If you do manage to copy your packages from...

Have you tried turning on the log file for the package. This supplies you with Execution Started and Execution Completed. To do this just go to PACKAGE / PROPERTIES from the menu in the DTS Package and then click on the Logging tab. Enter a filename into the Error handling section. Hope this...

Depending on the users access to the folders (if you haven't changed this then they will see all of the folders and fields) then they will be able to create their own reports. Though the effectiveness of their report writing will be dependant on their understanding of the data, naming convention...