Recent content by Gunnien

Hello, You may find something useful here: http://opensource.bureau-cornavin.com/belkin/

Database default for '' is '01/01/1900' so the only you achieve with this statement: CASE c.closeDate WHEN '01/01/1900' THEN '' ELSE c.closeDate END AS [closeDate], is to replace '01/01/1900' with '01/01/1900'. Try this one: CASE c.closeDate WHEN '01/01/1900' THEN NULL ELSE c.closeDate END...

The database default NULL value is not 01/01/1900, but when one or another input-query sets the are setting the value to '' the database replaces this with 01/01/1900 to avoid an error that stops the work-flow. And when you use this this statement in order to retrieve a blank field where the...

I think the select part of your query is the wrong one inless the select * only returns this value "Hours.wdate". So my suggestion is that your query to: Select Hours.wdate, Other...., SUM(Hours.whours) From Clin JOIN Hours ON Clin.Clin = Hours.Clin JOIN...

It's strange how much help I can find here. Even when I am reading my own issue posted a litle bit earlyer here. One way round my problem is as simple as cretate a dimension by: CASE WHEN Datediff(dd,Datamarts.dbo.Sales_OrderStatistics."Entry date...

Hello, I am trying to create a webi report that are supposed to show the number of early customer orders by counting the unike order numbers. The reason I want to do this in webi is to distribute the report to a bigger number of users with the possibility to drill down in the report. In order...

Do you have access to a computer that may boot from a CD? If so you can boot up from the knoppix CD and create a boot disk by running the "mkbootfloppy" program. Gunnien

Hello, First of all, I am using BusinessObjects 6.5.1. I have a litle problem with a mesure in my sales order statistics universe. I am interested in the number of customers orders with a horizom greater then or equal to 14 days. Each customer order may have more than one order line so I am...

Hi, A while ago I tryed to install kylix on my Fedora box but gave up the whole project and went for Lazarus in stead. http://www.lazarus.freepascal.org/ Gunnien

Hello, It is possible, i truied this on the eFashion universe and it parses OK IIf(Calendar_year_lookup.Yr = 2004,"OK","NOT OK" ) Hopes it helps you Kind regards Gunnien

Hi, If you are new to mysql, this is a wery useful tool: http://dev.mysql.com/doc/mysql/en/index.html Else you can download some very useful administration tools from the mysql site. And I myself is used to ms databases and found the old "mysql control center" very useful since it is quiet...

Hello vani65, Thanks for confirming what I was afraid of. Big star to you :-) Gunnien

Hello all, I have a litle problem here that I cant find an answer for from other sources like the usermanual and the net. I am working with BO 6.5 and creating reports in webi. Some in our system has decided to use a developent envirement to create all reports and test those before they...

Hell again, I have to post this litle message, to say that I made a fool out of my self. I found a link here in about "how to ask smart questions" and read it. And specially the chapter about the before you ask....... and took the hint and did that "STFW" stuff fore a couple of hours and...

Hello, I have a simple “Dell Inspiron” set up with Both Fedora (FC3) and Win2k. But the space on the disk is starting to be a limitation so I am thinking on scrapping the win system. But there is one thing I should have solved before I scrap the win and that is the wireless network connection...