Can we edit the relationship in Database diagram

I am using SQL 2005.
I have define a relationship between two tables in Database Diagrams.
I want to change setting of the relationship, but I can't find out how to
modify it.
Can we edit the relationship in Database diagram?
You can , right click on any of the tables in the database diagram,
click on the relationship
Chirag Shah
ad wrote:
> I am using SQL 2005.
> I have define a relationship between two tables in Database Diagrams.
> I want to change setting of the relationship, but I can't find out how to
> modify it.
> Can we edit the relationship in Database diagram?

Can we edit the relationship in Database diagram

I am using SQL 2005.
I have define a relationship between two tables in Database Diagrams.
I want to change setting of the relationship, but I can't find out how to
modify it.
Can we edit the relationship in Database diagram?You can , right click on any of the tables in the database diagram,
click on the relationship
Chirag Shah
ad wrote:
> I am using SQL 2005.
> I have define a relationship between two tables in Database Diagrams.
> I want to change setting of the relationship, but I can't find out how to
> modify it.
> Can we edit the relationship in Database diagram?sql

Can we edit the relationship in Database diagram

I am using SQL 2005.
I have define a relationship between two tables in Database Diagrams.
I want to change setting of the relationship, but I can't find out how to
modify it.
Can we edit the relationship in Database diagram?You can , right click on any of the tables in the database diagram,
click on the relationship
Chirag Shah
ad wrote:
> I am using SQL 2005.
> I have define a relationship between two tables in Database Diagrams.
> I want to change setting of the relationship, but I can't find out how to
> modify it.
> Can we edit the relationship in Database diagram?

Can we define multiple key columns for a mining structure?

Hi, all,

Just found that we are not able to define multiple key columns for a mining structure in SQL Server 2005 Data Mining engine, just wondering is there other way to define multiple key columns for a mining structure there? As in many cases, the table we are mining are with composite key consisting of different foriengn keys, e.g. A fact table are with transaction information and other foreign keys. If I am not able to define these composite key here for this fact table, I will have to have a named calculation in data source view to have a key column which is based on these original composite keys? Is this a better way to solve this problem or there is any other alternatives to figure it out?

Hope my question is clear for your help and I am looking forward to heaing from you shortly for your kind advices and help and thanks a lot in advance.

With best regards,

Yours sincerely,

Multiple key columns are not permitted in a mining structure. However, you can specify multiple bindings for the Key column in the mining structure: in the Mining Structure tab in BI Dev Studio, click on KeyColumns in the Properties pane and then click on the "..." button in the value field to bring up an editor that allows you add additional bindings. You will also need to specify a NameColumn binding (the next field in Properties) that binds to a source that contains unique names for the composite key you've specified via the multiple bindings under KeyColumns.

The option you suggest (adding a named calculation in the DSV) will also work.

|||

Hi, Raman,

Thanks for your advices.

But still we need a name column whenever we have a muitiple columns bindings for the key attribute?

With best regards,

Yours sincerely,

|||Yes, that's correct - otherwise the server does not know what to name the composite key value (it can't do a simple concatenation because of type differences).|||

Hi, Raman,

Thanks.

Best regards,

Yours sincerely,

Can we define dynamic calculation members?

Hi, all here,

I am also wondering is there any way for us to define dynamic calculation members across different levels? (e.g. whatever dimension levels you are browsing you will be able to see the calculated members bound to the particular dimension level you are browsing).

Hope it is clear for your kind advices and help.

I am looking forward to hearing from you shortly for your help.

With best regards,

Yours sincerely,

If you are using MDX (in a query) to calculate your members, I believe if you reference .CurrentMember in any of the attributes/dimensions the calculated member will live in the scope of the Where clause of the query.

If defining it as a calculated measure in the cube, I think it automatically adjusts to the scope of the query.

You can also read up on the SCOPE statement here : http://technet.microsoft.com/en-us/library/ms145989.aspx

Good luck,

John

Can we define dynamic calculation members?

Hi, all here,

I am also wondering is there any way for us to define dynamic calculation members across different levels? (e.g. whatever dimension levels you are browsing you will be able to see the calculated members bound to the particular dimension level you are browsing).

Hope it is clear for your kind advices and help.

I am looking forward to hearing from you shortly for your help.

With best regards,

Yours sincerely,

If you are using MDX (in a query) to calculate your members, I believe if you reference .CurrentMember in any of the attributes/dimensions the calculated member will live in the scope of the Where clause of the query.

If defining it as a calculated measure in the cube, I think it automatically adjusts to the scope of the query.

You can also read up on the SCOPE statement here : http://technet.microsoft.com/en-us/library/ms145989.aspx

Good luck,

John

Can not run script.

Hi,
I have to scripts, one is use to create table and
another one is use to create user define function. I want
to check why i can run the script to create table but i
can not run the script to create user define function. Is
it got any restriction in security? What i can check? Is
it security problem?
Any suggestion of where i can check?
Any help is much appreciated.
regards,
florenceHi,
To execute it directly m you have to be in any one of the below database
roles,
1. db_owner
2. db_ddladmin
SA can also give the user exclusive "Create FUNCTION" prev.
Grant Create Function to username
Thanks
Hari
MCDBA
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:906b01c3ea41$7cd6eda0$a001280a@.phx.gbl...

quote:

---

> Hi,
> I have to scripts, one is use to create table and
> another one is use to create user define function. I want
> to check why i can run the script to create table but i
> can not run the script to create user define function. Is
> it got any restriction in security? What i can check? Is
> it security problem?
> Any suggestion of where i can check?
> Any help is much appreciated.
> regards,
> florence

---