Showing posts with label members. Show all posts
Showing posts with label members. Show all posts

Tuesday, March 27, 2012

Can we drill through to details for calculated members?

Hi, experts,

Can we drill down to details for calculated members of a cube? Or we can only drill through to details for measures residing in a specific measure group in a cube?

Hope it is clear for your help.

I am looking forward to hearing from you shortly and thanks a lot in advance.

With kind regards,

Yours sincerely,

Drilldown (navigating in a hirarchy tree) is possible through all members - even calculated once

I guess what you ask is drillthrough (http://technet.microsoft.com/en-us/library/ms145964.aspx) and this works only on base measures as far as I know. (SQL Server 2005)

HANNES

|||

Hi, Hannes,

Thanks a lot for your help.

Sorry for the mistyping, yes, I was asking for 'drill through' capability for calculated members.

Thanks again.

With kindest regards,

Yours sincerely,.

|||

Hello you two,

Today I searched a solution for this problem too.

And I came to the same result as you are.

Then my result is right … I hope so =)

Have a nice day

Alex

|||

Hello experts,

I’ve got an idea but I don’t know how to continue ….

I thought if you can’t make a drillthrough on a calculated member I can program one.

On the website Microsoft technet I found the code snippet:

DRILLTHROUGH [MAXROWS Unsigned_Integer] <MDX SELECT statement> [RETURN Set_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]

But where is the point to take it in?

Best regards

Alex

|||

Hi,

if your question is- with which programm could you execute an drillthrough statement?

SQL Server Management Studio - its a regular MDX Statement.

Best regards, HANNES

|||

Hello Hannes,

Thanks for the response. I know that, but I searched for a possibility to upgrade the cube through programming some parts.

Best regards, Alex

Can we drill down to details for calculated members?

Hi, experts,

Can we drill down to details for calculated members of a cube? Or we can only drill through to details for measures residing in a specific measure group in a cube?

Hope it is clear for your help.

I am looking forward to hearing from you shortly and thanks a lot in advance.

With kind regards,

Yours sincerely,

Drilldown (navigating in a hirarchy tree) is possible through all members - even calculated once

I guess what you ask is drillthrough (http://technet.microsoft.com/en-us/library/ms145964.aspx) and this works only on base measures as far as I know. (SQL Server 2005)

HANNES

|||

Hi, Hannes,

Thanks a lot for your help.

Sorry for the mistyping, yes, I was asking for 'drill through' capability for calculated members.

Thanks again.

With kindest regards,

Yours sincerely,.

|||

Hello you two,

Today I searched a solution for this problem too.

And I came to the same result as you are.

Then my result is right … I hope so =)

Have a nice day

Alex

|||

Hello experts,

I’ve got an idea but I don’t know how to continue ….

I thought if you can’t make a drillthrough on a calculated member I can program one.

On the website Microsoft technet I found the code snippet:

DRILLTHROUGH [MAXROWS Unsigned_Integer] <MDX SELECT statement> [RETURN Set_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]

But where is the point to take it in?

Best regards

Alex

|||

Hi,

if your question is- with which programm could you execute an drillthrough statement?

SQL Server Management Studio - its a regular MDX Statement.

Best regards, HANNES

|||

Hello Hannes,

Thanks for the response. I know that, but I searched for a possibility to upgrade the cube through programming some parts.

Best regards, Alex

Can we drill down to details for calculated members?

Hi, experts,

Can we drill down to details for calculated members of a cube? Or we can only drill through to details for measures residing in a specific measure group in a cube?

Hope it is clear for your help.

I am looking forward to hearing from you shortly and thanks a lot in advance.

With kind regards,

Yours sincerely,

Drilldown (navigating in a hirarchy tree) is possible through all members - even calculated once

I guess what you ask is drillthrough (http://technet.microsoft.com/en-us/library/ms145964.aspx) and this works only on base measures as far as I know. (SQL Server 2005)

HANNES

|||

Hi, Hannes,

Thanks a lot for your help.

Sorry for the mistyping, yes, I was asking for 'drill through' capability for calculated members.

Thanks again.

With kindest regards,

Yours sincerely,.

|||

Hello you two,

Today I searched a solution for this problem too.

And I came to the same result as you are.

Then my result is right … I hope so =)

Have a nice day

Alex

|||

Hello experts,

I’ve got an idea but I don’t know how to continue ….

I thought if you can’t make a drillthrough on a calculated member I can program one.

On the website Microsoft technet I found the code snippet:

DRILLTHROUGH [MAXROWS Unsigned_Integer] <MDX SELECT statement> [RETURN Set_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]

But where is the point to take it in?

Best regards

Alex

|||

Hi,

if your question is- with which programm could you execute an drillthrough statement?

SQL Server Management Studio - its a regular MDX Statement.

Best regards, HANNES

|||

Hello Hannes,

Thanks for the response. I know that, but I searched for a possibility to upgrade the cube through programming some parts.

Best regards, Alex

Can we drill down to details for calculated members?

Hi, experts,

Can we drill down to details for calculated members of a cube? Or we can only drill through to details for measures residing in a specific measure group in a cube?

Hope it is clear for your help.

I am looking forward to hearing from you shortly and thanks a lot in advance.

With kind regards,

Yours sincerely,

Drilldown (navigating in a hirarchy tree) is possible through all members - even calculated once

I guess what you ask is drillthrough (http://technet.microsoft.com/en-us/library/ms145964.aspx) and this works only on base measures as far as I know. (SQL Server 2005)

HANNES

|||

Hi, Hannes,

Thanks a lot for your help.

Sorry for the mistyping, yes, I was asking for 'drill through' capability for calculated members.

Thanks again.

With kindest regards,

Yours sincerely,.

|||

Hello you two,

Today I searched a solution for this problem too.

And I came to the same result as you are.

Then my result is right … I hope so =)

Have a nice day

Alex

|||

Hello experts,

I’ve got an idea but I don’t know how to continue ….

I thought if you can’t make a drillthrough on a calculated member I can program one.

On the website Microsoft technet I found the code snippet:

DRILLTHROUGH [MAXROWS Unsigned_Integer] <MDX SELECT statement> [RETURN Set_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]

But where is the point to take it in?

Best regards

Alex

|||

Hi,

if your question is- with which programm could you execute an drillthrough statement?

SQL Server Management Studio - its a regular MDX Statement.

Best regards, HANNES

|||

Hello Hannes,

Thanks for the response. I know that, but I searched for a possibility to upgrade the cube through programming some parts.

Best regards, Alex

sql

Can we drill down to details for calculated members?

Hi, experts,

Can we drill down to details for calculated members of a cube? Or we can only drill through to details for measures residing in a specific measure group in a cube?

Hope it is clear for your help.

I am looking forward to hearing from you shortly and thanks a lot in advance.

With kind regards,

Yours sincerely,

Drilldown (navigating in a hirarchy tree) is possible through all members - even calculated once

I guess what you ask is drillthrough (http://technet.microsoft.com/en-us/library/ms145964.aspx) and this works only on base measures as far as I know. (SQL Server 2005)

HANNES

|||

Hi, Hannes,

Thanks a lot for your help.

Sorry for the mistyping, yes, I was asking for 'drill through' capability for calculated members.

Thanks again.

With kindest regards,

Yours sincerely,.

|||

Hello you two,

Today I searched a solution for this problem too.

And I came to the same result as you are.

Then my result is right … I hope so =)

Have a nice day

Alex

|||

Hello experts,

I’ve got an idea but I don’t know how to continue ….

I thought if you can’t make a drillthrough on a calculated member I can program one.

On the website Microsoft technet I found the code snippet:

DRILLTHROUGH [MAXROWS Unsigned_Integer] <MDX SELECT statement> [RETURN Set_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]

But where is the point to take it in?

Best regards

Alex

|||

Hi,

if your question is- with which programm could you execute an drillthrough statement?

SQL Server Management Studio - its a regular MDX Statement.

Best regards, HANNES

|||

Hello Hannes,

Thanks for the response. I know that, but I searched for a possibility to upgrade the cube through programming some parts.

Best regards, Alex

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

Tuesday, March 20, 2012

Can this be done with an output parameter?

Hi I want to make a Function in my User class that adds new members into the db. What I want to do is add the users details in using a stored procedure and input parameters and then return a parameter indicating their userid value and set it to a variable.

My userid column in the my db is auto incrementing with a seed of 1 and a step value of 1.

How could I create an output parameter that would return their new user id and then how would i set it to an integer variable.

Thanks::How could I create an output parameter that would return their new user id and then how
::would i set it to an integer variable

do you mean from the front end or inside the stored proc ?

if you mean the stored proc:


create procedure <name> ( @.param1 nvarchar(25),@.param2 int, @.userid int OUTPUT)
as

insert into ( ....) values (...) select @.userid=@.@.IDENTITY
..


HTH|||Use the OUTPUT Parameter of the Stored Procedure. Refer to SQL Server BOL for further assitance ...|||Hi yeah I mean by using the output param in the sp.

How does the @.@.Idendity work then?

How would i set this to a varialble in my front end. Would I use

Dim UserID as Integer

Dim objParam as New SqlParameter("@.@.Idendity", SqlDbType.Int)
objParam.Direction = ParameterDirection.Output
objParam.Value = UserID
objComm.Parameters.Add(objParam)

Thanks|||First, you should use SCOPE_IDENTITY(), not @.@.IDENTITY.

Next, use a SP like this:


create procedure <name> ( @.param1 nvarchar(25),@.param2 int, @.userid int OUTPUT)
as

insert into ( ....) values (...)

select @.userid=SCOPE_IDENTITY()

then


Dim objParam as New SqlParameter("@.UserID", SqlDbType.Int)
objParam.Direction = ParameterDirection.Output
objComm.Parameters.Add(objParam)

Then after the command is run, check objComm.Parameters("@.UserID") for the UserID|||Many thanks Douglas. We may have to start calling you superman on here lol as you come to everyones rescue.|||Thanks. I do have the glasses, though no cape, and no one wants to se me in tights<g>.