Showing posts with label browsing. Show all posts
Showing posts with label browsing. Show all posts

Monday, March 12, 2012

How can we replace any null cells with a particular value instead?

Hi, all experts here,

Thank you very much for your kind attention.

I am wondering if there is any way to replace all null cells when browsing dimensions dynamically? As when we browse cube data with whatever dimensions hierarchies etc. on rows and columns we always get some null cells which have not intersections between those selected dimension hierarchies on columns and rows at all as we never be able to know where null cells are. Therefore in order to make things better (looking better) like in client tool ProClarity, I want to find a way to replace those null cells with a particular value to make the reports look better?

Is it possible to achieve this in SQL Server 2005 Analysis Services and which can be inherited in its clients as well (e.g. ProClarity)? I am looking forward to hearing from you shortly and thanks again for your help.

With best regards,

Yours sincerely,

Hello Helen! In ProClarity you have two buttons in the dimension tool that will remove empty rows and columns in a table.

Be aware that the NON EMPTY buttons will only remove rows and columns where all the cells a null.

If you enter other values, with the MDX IIF-statement in a calculated member, or format-options(in the Calculations tab in the cube editor) you can hurt query performance.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for that.

The question to me is, some null cells on some rows where not the whole rows are empty. E.g some cells of those rows are with values, some are not. Therefore it does not look nice. So I want to replace them. But then as you kindly suggested replacing them with other values you have to add calculated members which to some extent hurt performance query. Therefore I think it is better to leave them as they are to the end users.

Thank you very much again for your kind help.

With best regards,

Yours sincerely,

Friday, March 9, 2012

How can users "download" cubes to their local machines?

Hi,

I read in oneof the articles somewhere that users can also download cubes to their local machines for off-line browsing/analysis. This can be very useful if the user is suppose away from the office or not connected to the LAN.

I wanted to request if someone can explain the process of how users can do this i.e. download/save a copy of the cube to their local machines?

Thanks.Use Excel
Somewhere is opction to save it as a local cube, use help|||Como Estas rafala

Thanks for the reply. Gracias ;)

So is it correct to assume that downbloading of cubes to local machine is ONLY possible if the front-end being used forcube analysis is Excel?

I'll appreciate a confirmation.|||http://www.winnetmag.com/SQLServer/Article/ArticleID/22394/22394.html|||http://www.winnetmag.com/Article/ArticleID/22394/22394.html