can we export olap cubes from sql server 2005 analysis service to sql server 2000 analysis servi

Dear all,

Thank you very much for your kind attention.

Is it possible to export olap cubes from sql server 2005 analysis service to sql server 2000 analysis service? And if it is possible, then how can it be done? Really need help for this and thank you very much in advance for your help.

I am looking forward to hearing from you.

With best regards,

Yours sincerely,

Helen

No, it isn't possible to export cubes from AS2005 to AS2K. You'll have to rebuild them from scratch, I'm afraid.

Regards,

Chris

|||

Hi, Chris,

Thank you for your advice.

With best regards,

Yours sincerely,

Helen

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 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