Question to Thread " Usage of Association Rules"

"If you have a pressing need for this fix, please contact our customer support team."

Yes I have a pressing need for this fix, where I have to contact your customer support team. How do I do that?

You know I only have the evaluation version of SQL Server, but I have to show that this programm is good enough to solve Association Analysis. If I can not show this it wouldn't be bought. Please help me.

TNX

Answered on other thread - http://support.microsoft.com

In this case, contact me at jamiemac "at" microsoft.com

Question on, usage of NOT IN

Hi All,
The following string comparision fails:
declare @.prodCode as nvarchar(50)
select @.prodCode = 'ABZC001'
if @.prodCode NOT IN ( 'ABZC001,CBQA03,FG0023')
BEGIN
...
...
END
The code within the BEGIN...END block is executed!
Any suggestions?
Thanks
kdIN / NOT IN takes a subquery or expression list as an argument. It won't
parse a string for you. I assume this is what you intend:
IF @.prodCode NOT IN ('ABZC001','CBQA03','FG0023')
If you want to search for substrings, use CHARINDEX or PATINDEX.
David Portas
SQL Server MVP
--

Question on dimension usage of cube

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the dimension usage of cube. When we relate the dimensions to measure groups, is it a must we have to use the key of the dimension to relate to the measure groups? Otherwise the analysis services server will not be able to correctly aggregate the cube data? Thank you very much and I am looking foward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello. Yes, you use the logical dimension key that you have in the datasource view. One exception is when you have a fact table with a month dimension and your time dimension have day/date as the lowest level. In the Adventure Works cube, that is part of the installation of SQL Server 2005, you have a relation like that between the date dimension and the Sales Targets measure group. That relation is defined between the Calendar Year and Calendar Quarter columns in the dimension usage tab.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot.

With best regards,

Yours sincerely,