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 drill down reports in a another different pages with different layouts?

Hi, all experts here,

Thank you for your kind attention.

I am wondering if we can drill down reports in a different page with different layouts and columns? e.g. I have too many columns desired to see in a report, so I want to direct the users to another page with different layouts and columns, so the first view in the report wont display so many columns in a page. Is it possible to make it in SQL Server 2005 Reporting Services? And if it is possible then how? Hope my question is clear for your help.

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

With best regards,

Yours sincerely,

Yes, you can use the Action property of your column textbox. When you look at the options, you can either jump to a new report or to a bookmark or to an URL. In your case, you may like to use Jump to Bookmark. Use BookmarkID for the tables or lists which are displayed in subsequent pages and use that ID to jump to, from your first page columns.

Shyam

|||

Hi, Shyam,

Thank you for your kind help and advice.

Yes, in the navigation property (action property), I can set the actions accordingly. But the pages I am going to will still get the same columns as in the first page. What I want is drill down to a page with different columns displayed? Is that possible? Thank you very much. And I am looking forward to hearing from you further.

With best regards,

Yours sincerely,

|||

In that case, you may have to navigate to a subreport which will have different layout. Create a subreport and jump to this subreport providing the necessary parameters.

Shyam

|||

Hi, Shyam,

Thanks a lot for your kind help.

With best regards,

Yours sincerely,

Can we create shared report parametres?

Hi, all experts here,

Is it possible to create shared report parametres passing among different reports on SQL Server 2005 Reporting Services? If it is possible, and how?

Thanks a lot in advance for your advices. And I am looking forward to hearing from you.

With best regards,

Yours sincerely,

No, it's not possible to create a shared parameter, though you can pass the parameter values from one report to another either on user action or to subreports.

Shyam

Can we create distinct values for document map on a particular level?

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question about document map on SQL Server 2005 Reporting Services. I found one problem with the values retrived for the document level. That is, the values are not distinct, they are duplicate for the document level. Is it possible for us to get the distinct values for a particular document level? Hope my question is clear for your help.

Thank you very much in advance for your help and advices. I am looking forward to hearing from you.

With best regards,

Yours sincerely,

Group your data in either the table or list (whatever you are using) and use document map for the group.

Shyam

|||

Hi, Shyam,

Thanks a lot for your kind advices.

Yes, jsut found out that cause I got more than one groups in my reports. And the document map level is not the first group there, so once I run the report, the document map on that level got duplicate values. Now it is clear.

Thank you very much.

With best regards,

Yours sincerely,

Can we alter system views in SQL Server 2005?

Hi, all experts here,

Thank you for your kind attention.

Would please anyoneh ere give me any advices about if we can alter system views in SQL Server 2005 ?

With best regards,

modifying system objects is no longer allowed in sql2k5...|||Can you let us know of your scenario which requires you to alter the system views ?|||

Hi, Asvin,

Thank you very much for your kind attention.

The original reason for me to wonder if it is possible to alter system objects was that since in SQL Server 2005 we got a INFORMATION_SCHEMA.COLUMNS view which collects the information about all the columns within the database, but what I think will be helpful is the description for the columns. Since I am currently having a large database with up to serveral hundred tables which got a large number of columns without any explanation for what are those columns about, as a result, it's been very difficult to understand the whole database to have further analysis based on it.

If database designer could put description for each column within the database, and at the same time add a column_descpription column into the INFORMATION_SCHEMA.COLUMNS within the system view, it will be very helpful for other users rather than database designers to understand the data well.

Hope my explanation above clear what my question is and thank you very much in advance for your further advices and guidance.

With best regards,

Yours sincerely,

|||

If that is your intent I would suggest that you add extended properties on the table columns. Take a look at this feature at http://msdn2.microsoft.com/en-us/library/ms190243.aspx.

or look it up in books online.

In short, extended properties let you add a description to any object in the database such as tables, views, schemas, columns etc.

e.g.

To add an extended property to a column of a table you could do something like

sp_addextendedproperty 'property_name','your description','schema','schema_name_of_table','table','table_name','column','column_name'

and then to retrieve it you can use the function fn_listextendedpropety or the catalog view sys.extended_properties.

select * from sys.fn_listextendedproperty('property_name','schema','schema_name_of_table','table','table_name','column','column_name') will return 'your description'.

Hope this helps and is a good starting point to solve your problem.

Please do not attempt to modify or change the system views in sql server. It will leave the database in a corrupt state.

Can we alter system views in SQL Server 2005?

Hi, all experts here,

Thank you for your kind attention.

Would please anyoneh ere give me any advices about if we can alter system views in SQL Server 2005 ?

With best regards,

modifying system objects is no longer allowed in sql2k5...|||Can you let us know of your scenario which requires you to alter the system views ?|||

Hi, Asvin,

Thank you very much for your kind attention.

The original reason for me to wonder if it is possible to alter system objects was that since in SQL Server 2005 we got a INFORMATION_SCHEMA.COLUMNS view which collects the information about all the columns within the database, but what I think will be helpful is the description for the columns. Since I am currently having a large database with up to serveral hundred tables which got a large number of columns without any explanation for what are those columns about, as a result, it's been very difficult to understand the whole database to have further analysis based on it.

If database designer could put description for each column within the database, and at the same time add a column_descpription column into the INFORMATION_SCHEMA.COLUMNS within the system view, it will be very helpful for other users rather than database designers to understand the data well.

Hope my explanation above clear what my question is and thank you very much in advance for your further advices and guidance.

With best regards,

Yours sincerely,

|||

If that is your intent I would suggest that you add extended properties on the table columns. Take a look at this feature at http://msdn2.microsoft.com/en-us/library/ms190243.aspx.

or look it up in books online.

In short, extended properties let you add a description to any object in the database such as tables, views, schemas, columns etc.

e.g.

To add an extended property to a column of a table you could do something like

sp_addextendedproperty 'property_name','your description','schema','schema_name_of_table','table','table_name','column','column_name'

and then to retrieve it you can use the function fn_listextendedpropety or the catalog view sys.extended_properties.

select * from sys.fn_listextendedproperty('property_name','schema','schema_name_of_table','table','table_name','column','column_name') will return 'your description'.

Hope this helps and is a good starting point to solve your problem.

Please do not attempt to modify or change the system views in sql server. It will leave the database in a corrupt state.

sql

Can Triggers Help Me out

Dear Experts,
I am storing the rates in pricelist table and these rates are used in
several tables.
Is is possible to create a trigger that will change rates in all the tables
wherever i have used the moment someone changes the rates in pricelist?
Thanks
Manish Sawjiani
Three Cheers to Technet for the Help!
Hi Manish
Triggers can help you, but u need to write
UPDATE <TABLE> ...
...
...
and so on, for all the tables that involved the price...
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.codecomments.com/gurus/default.asp?p=4223
"Manish Sawjiani" wrote:

> Dear Experts,
> I am storing the rates in pricelist table and these rates are used in
> several tables.
> Is is possible to create a trigger that will change rates in all the tables
> wherever i have used the moment someone changes the rates in pricelist?
> Thanks
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!
|||Manish Sawjiani wrote:
> Dear Experts,
> I am storing the rates in pricelist table and these rates are used in
> several tables.
> Is is possible to create a trigger that will change rates in all the
> tables wherever i have used the moment someone changes the rates in
> pricelist?
> Thanks
> Manish Sawjiani
Why not create a relationship between the rates and these other tables
if they need to be kept in sync with the main table? If that won't work,
you can use an update trigger and the inserted table to get a list of
all rows that were updated.
David Gugick
Imceda Software
www.imceda.com

Can Triggers Help Me out

Dear Experts,
I am storing the rates in pricelist table and these rates are used in
several tables.
Is is possible to create a trigger that will change rates in all the tables
wherever i have used the moment someone changes the rates in pricelist?
Thanks
Manish Sawjiani
--
Three Cheers to Technet for the Help!Hi Manish
Triggers can help you, but u need to write
UPDATE <TABLE> ...
..
..
and so on, for all the tables that involved the price...
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.developersdex.com/gurus/default.asp?p=4223
---
"Manish Sawjiani" wrote:
> Dear Experts,
> I am storing the rates in pricelist table and these rates are used in
> several tables.
> Is is possible to create a trigger that will change rates in all the tables
> wherever i have used the moment someone changes the rates in pricelist?
> Thanks
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!|||Manish Sawjiani wrote:
> Dear Experts,
> I am storing the rates in pricelist table and these rates are used in
> several tables.
> Is is possible to create a trigger that will change rates in all the
> tables wherever i have used the moment someone changes the rates in
> pricelist?
> Thanks
> Manish Sawjiani
Why not create a relationship between the rates and these other tables
if they need to be kept in sync with the main table? If that won't work,
you can use an update trigger and the inserted table to get a list of
all rows that were updated.
--
David Gugick
Imceda Software
www.imceda.comsql