Question on validation of mining models

Hi, guys,

Thanks for your kind attention.

Just want to make things perfectly work and make the most of our fantastic SQL Server 2005 Data Mining Engine. Can any of you here give me some super advices on the validation of the mining models. As we always see, the 3 aspects of a mining model are: Score, Population correct, and Predict Probability. So the question is: How can we combine these three aspects to best judge the mining models by being able to tell which model is the best one? And to what extent can we really trust these mining models?

These are very important before we can actually bring the models into work to convince other people who have no ideas what are going on with these models. Yes, we just want to convince them with the results of these models and make the most of them and best help them getting the most from their business operations etc.

By the way please can you explain a bit details on each of these aspects? Thanks again.

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

With best regards,

Yours sincerely,

Hi, Guys,

I am still waiting for your advices.

Thanks.

With best regards,

Yours sincerely,

|||

I heard about a book "Quality Measures in Data Mining" by Fabrice Guillet and Howard J. Hamilton. It may contain some super advices.

Gigi Ciubuc

www.sqlserver.ro

|||

Hi, Gigi Ciubuc,

Thanks for the imformation. Any other ideas from any other experts here as well?

Thanks.

With best regards,

Yours sincerely,

Question on URL action on cube objects

Hi, all experts here,

Thanks a lot for your kind attention.

I am having a question on the URL action on cube objects. The question is about the URL expression. It seems like we cant jsut pasted the URL there?

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

With best regards,

Yours sincerely,

No, you need to supply an MDX expression which resolves to a url. So if you just want to hard-code a url in your action, you need to enclose it in double quotes, for example

"http://www.google.com"

HTH,

Chris

|||

Thanks a lot.

Best regards,

Question on shared cube dimensions and measure groups

Hi, all experts here,

Thank you very much for your kind attention.

I am wondering is there anyway of sharing dimensions and measure groups between different cubes? Like if we want to create a new cube, we dont need to reselect its data source and data source view, instead we can select dimensions and measure groups of other cubes?

Hope it is clear for your advices and I am looking forward to hearing from you shortly and thanks a lot in advance for your help.

With best regards,

Yours sincerely,

Hi Helen,

Dimensions can be shared between all cubes inside an AS2005 Database. In order to use dimensions and/or measure groups in multiple cubes you only need to create the cubes inside the same AS2005 database.

hth,

Eric

|||

Hi, Eric,

Thanks a lot for your kind attention.

But in BI studio, yes, I did create a new cube within the same analysis services project which no dount will deploy the cube to the same SSAS2005 database, but whenever I create a new cube with the cube creation wizard, I have to select the new data source view for new dimensions and measure groups again? Could you please shed me any light which UI is available to create new cube with dimensions and measure groups from existing cube?

Hope it is clear for your further advices and I am looking forward to hearing from you shortly and thanks a lot in advance for your help.

With best regards,

Yours sincerely,

|||

Hi,

The cube wizard allows you to use existing dimensions. In the "Identify Fact and Dimension Tables" page, select no dimension tables and in the next page, "Review Shared Dimensions", you can pick the existing dimensions to include in the new cube.

Adrian Dumitrascu

|||

Hi, Adrian,

Thanks a lot for your help.

With best regards,

Yours sincerely,

sql

Question on sequence clustering algorithm

Hi, all experts here,

Thank you very much for your kind attention.

I have a question on sequence clustering algorithm. As generally it is used for sequence analysis especially for web path visiting analysis. Besides that, what else scenarios could we apply this algorithm as well?

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

With best regards,

Yours sincerely,

It is specifically for sequence analysis, but the sequence can be anything.

E.g. operations at work, product purchase order, user-behavior studies, tv-channel surfing etc. etc. Whenever you have arbitrarily different sequences of distinct events you can use the SC algorithm to understand the sequences involved. One limitation is that the algorithm works well only with a limited number of sequence states. For example, if I tried to sequence ALL web pages on SQLServerDataMining.com, it likely wouldn't work well, but if I classified pages by type, e.g. home page, tip/trick, whitepaper, download, image, etc, and sequenced the types, it could give a lot of insight.

|||

Hi, Jamie,

Thanks a lot for your advices. So as you kindly advised, the SC algorithm works well to cases with limited number of states, could you kindly advise me further like, to what extent the limited number of states are? Hope my question is clear for your further advices.

Thanks a lot.

With best regards,

Yours sincerely,

|||Generally less than 100. If you think about it, it's hard to find web sites with more than 100 types of pages.....|||

Hi, Jamie,

Thanks a lot for your advices.

Best regards,

Yours sincerely,

Question on PMML for data mining

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the PMML for data mining. As we know PMML enables the deployment of data mining models over all the major data mining vendors' data mining platform. I want to make sure what features of data mining models are exchanged actually? Are only the contents of the mining models? Or all the relative features (from data source, data source view, atrtibutes etc. ) ? And can we reprocess the data mining models from the destination platform where the mining models are deployed different from where they are created?

I am looking foreward to hearing from you shortly and thank you very much.

With best regards,

Yours sincerely,

PMML exports only the content of the mining model.

Data Source and Data Source View information is not exported, because these are specific to Microsoft Analysis Services Data Mining. So, in order to reprocess a mining model imported using PMML, you must ensure that the columns in the data dictionary section of the PMML file are available in the mining structure.

Similarly, if importing to a different destination, you would need to ensure that the columns in the data dictionary section of the PMML file could be bound to available columns.

|||

Hi, Donald,

Thank you so much for your advices. It's been very helpful for me.

With best regards,

Yours sincerely,

Question on particular report region layout properties

Hi, all experts here,

Thanks a lot for your kind attention.

I have been trying to adjust the report regions fit into the whole report page. I could see the width and height property of the whole report page from the report property dialogue, but where can I find the width and height for the particular report region like the table? Then I could accordingly adjust the layout of both the report page and report region like table?

Hope my question is clear for your help.

With best regards,

Yours sincerely,

Clicking on the top left corner of the table object, you can see the properties of the table. There should be a Size property that has width and height.

Hope this is what you're looking for.

cheers,

Andrew

|||

Hi, Andrew,

Thanks a lot for your kind suggestion.

Yes, I clicked on the left corner of the table and the table property dialogue box appeared, but there is no size property there.

Any futher advices? I am looking forward to hearing from you further shortly.

Thanks a lot again.

With best regards,

Yours sincerely,

|||

Did you click twice & hit F4 to see the properties window? That is strange. You can also click anywhere on the report and hit tab to cycle through the controls, or hit F4 to view the properties window and select the table from the drop down list.

cheers,

Andrew

|||

Hi, Andrew,

Thanks a lto for your kind advice.

By all means I could be able to make it work. Jutst wondering a simpler way of doing it.

With best regards,

Yours sincerely,

Question on packages deployment

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the deployment of the packages to integration services server. Why after I have deployed the whole solution, but my packages are not actually deployed to the integration services server?

Also, after we add the package manually to the integration services server, to users outside of local host, how could we add permissions for them to execute the packages?

Thanks a lot in advance for your help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hi Helen999888,

I'm not sure how you are deploying the packages or what you mean when you say "add the package manually". Can you provide some detail about your current procedure?

I like to use the Deployment Utility for deployment. In Solution Explorer, right-click the project name and click Properties. On the Deployment Utility page, set the CreateDeploymentUtility property to True. The next time you build the project, a Deployment subdirectory will be created under the bin directory in the project path. Inside this directory will be at least two files: one for each package in the solution and another named the same as the project with the extension: SSISDeploymentManifest. If you double-click the SSISDeploymentManifest file, the SSIS Deployment Wizard starts and will walk you through deploying the package(s) in your project.

There are many ways to execute SSIS packages:

Manually - in either Business Intelligence Development Studio or using DTExecUI. Command Line - using DtExec. SQL Agent Job - using the SQL Server Integration Services step type.|||

Hi, Andy,

Thanks a lot for your advices and help.

With best regards,

Yours sincerely,

Question on OLAP cubes storage modes

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the SSAS2005 OLAP Cubes storage modes. We know SSAS2005 supports 3 different storage modes: ROLAP, MOLAP, HOLAP.

Do all these three storage modes of cubes store data in another physica analysis services databases which are inrelative from their data warehouse (in case they are built on top of the data warehouse)? (so it does not matter at all even we remove the data warehouse?)

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

With best regards,

Yours sincerely,

Pl refer to BOL for detail explanation.

ROLAP - Data is in data warehouse (relational database). The data warehouse cannot be removed in this case

MOLAP - The data warehouse can be removed as both the data and aggregations are stored in the SSAS server. But if you want to see the updated data, then u may need the data warehouse.

HOLAP - The data warehouse cannot be removed in this case

|||

Hi, Arun,

Thank you very much for your kind and very helpful advices.

But the question is: in MOLAP mode, will it to a big extent the MOLAP cubes will slow down in processing once the underlying data warehouse is updated (in this case, any changes to the underlying data warehouse is informed to the MOLAP Cube, even we have set paralle cube partitions for that)

With best regards,

Yours sincerely,

|||

Depends on type of update you are performing. One way is to enable proactive caching to update the data based on some criteria - but the time taken depends on the amount of data read (plus also other criteria)

for ex, in one of our cubes, we use SQL CLR procs to perform incremental updates to partitions. It is very fast and takes only few seconds to update the MOLAP partitions. We trigger the sproc using messages from SQL broker.

|||

Hi, Arun,

Thank you very much for your kind advices. So as you kindly advised, in you case, you first of all perform updates to the source relational database partitions with SQL CLR procedures. Then again perform the updates to MOLAP partitions which takes only a few seconds. Is that right? It is a very interesting way to do that and I would say very advanced as well (assume I am right in understanding your advices for that.).

Thanks a lot again.

With best regards,

Yours sincerely,

|||

Its partially right. The updates to data warehouse (relational database) happens through many scenarios - SSIS packages, stored procedures etc.

But, I call a SQL server SP towards end of each of the events. That SP would post message to SQL broker Queue. (The purpose of doing this is to make all the process asynchronous). The target queue has an activation SP that will then invoke the neccesary CLR SP which would do all updates to SSAS.

The CLR SP uses AMO to do all updates to the cube. It also fires some XMLA queries to do some quick updates.

The above process works very well and the advantage is that its quite fast.

|||

Hi, Arun,

Thanks a lot for your kind advices and detailed explanation.

I guess it is really up to the specific problem. Anyway, very good advices.

Thanks again.

With best regards,

Yours sincerely,

Question on Links coefficiency of dependency network

Hi, guys,

Thanks for your kind attention.

Just wonder is there any way to get the link value on dependency network? Yes, I know we can move along the slider to get the link strength between different attributes. However, it will be more convinced that if we can get the value of the links and say we have a standard for it to judge if the link is truly strong enough?

Thanks in advance for your advices.

And I am very much looking forward to hearing from you.

With best regards,

Yours sincerely,

You could use the Profiler to see the calls executed against the server when the dep net viewer is populated.

If you execute the stored procedure from, say, SSMS, you will get back the whole serialized graph, with the weight associated with each edge

|||Data Mining Add-in for Visio can show edge strength (there is a button for it in the Data Mining toolbar).|||

Hi, thanks for the advices.

Best regards,

Yours sincerely,

Question on large volume of training dataset

Hi, all experts here,

Thanks a lot for your kind attention.

I have a question on training large volume of datasets. In this case, the training will take a long while to complete, is there anything we can do to improve that? I know, we obviously cant split the training dataset into different smaller datasets. What we can do to improve that?

Hope my question is clear for your help.

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

With best regards,

Yours sincerely,

Generally, the performance of the training operation depends on the size of the training set and there is not much one can do about this. Sometimes, the accuracy of the model is not improved significantly by adding new data. you might try smaller samples first and see if you really need all the data.

Certain optimizations could be done, depending on the algorithm. For example, if you are using the Neural Network algorithm you might want to make sure that the continuous columns are treated as continuous and not discretized, particularly if the the column is predictable. Also, make sure the model does not include unnecessary columns and only the required columns are marked as Predictable.

All these would improve the performance, but not significantly

Alternately, if you are trying just to do some sort of data exploration, you might want to start with Naive Bayes, which takes little time for training.|||

Hi, Bogdan,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

Question on granularity of OLAP cubes

Hi. all experts here,

Thank you very much for your kind attention.

As we all know one of the most significant benefits of OLAP cubes are to preaggregate the data based on different levels of the OLAP cubes. Therefore, in order to optimize the query performance against the huge OLAP data source, we can design the granularity for a OLAP cube and when necessary we can refer back to the underlying relational database sources. But the question here is: Is there any best practices on granularity of the OLAP cubes?

Hope my question is clear for your kind advices and help.

And I am looking forward to hearing from you shortly for your kind advices and thanks a lot in advance.

With best regards,

Yours sincerely,

Hi Helen,

U need to go through with OLAP Design Best Practices for Analysis Services 2005 or Data Warehouse Design Considerations

Bhudev

Question on filter itemset by up to one attribute in Association Rules

Hi, all experts here,

Thanks for your kind attention.

I want to filter the itemsets or rules based on more than 2 attributes, how can we achieve that? (I can only filter them by only one attribute?). Is it possible to achieve that?

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

With best regards,

Yours sincerely,

The filter actually can specify a regular expression, using the .Net language for regular expressions (the RegEx class).

Assume that you want any items set that include the Helmets and Fenders attributes, in any order

Here is an example of such filter:

((.*Helmets.*Fenders.*)|(.*Fenders.*Helmets.*))|||

Hi, are you saying this can be achieved in the association rules viewer?

Thanks.

|||Yes. In the filter, type directly the regular expression|||

Hi, Bogdan,

Thanks a lot.

Best regards,

Question on dimension usage of cube

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the dimension usage of cube. When we relate the dimensions to measure groups, is it a must we have to use the key of the dimension to relate to the measure groups? Otherwise the analysis services server will not be able to correctly aggregate the cube data? Thank you very much and I am looking foward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello. Yes, you use the logical dimension key that you have in the datasource view. One exception is when you have a fact table with a month dimension and your time dimension have day/date as the lowest level. In the Adventure Works cube, that is part of the installation of SQL Server 2005, you have a relation like that between the date dimension and the Sales Targets measure group. That relation is defined between the Calendar Year and Calendar Quarter columns in the dimension usage tab.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot.

With best regards,

Yours sincerely,

Question on dimension types in a cube

Hi, all experts here,

Thanks a lot for your kind attention.

I am wondering dose it really matter if the dimension types we set for each dimension will really affect anything wihin a cube?(like normally the default dimension type is regular, but there are many other dimension types like promotion, product etc. ), so do these dimension types will really affect anything for the cube data? If so, like what would be affected and changed?

I am looking forward to hearing from you shortly and thank you very much in advance for your help and advances.

With best regards,

Yours sincerely,

The only two types which affect semantics are:

1. Time - for MDX functions such as YTD and for semiadditive measures

2. Account - for Account Intelligence

Everything else are metadata that client applications can use for UI and other purposes.

|||

Hi,

Thanks a lot.

With best regards,

Yours sincerely,

|||

Dear Helen

Pleasae help me.. How can I create an attribute dateoforder in Sales dimension ...

Please help ..

Question on detach/attach database

Hi, all experts here,

Thank you for your kind attention.

I am having a question on detach/attach database. As when we detach/attach database, we have to copy both of .mdf and .ldf files to the targeted filepaths, in this case, when the database is large, then it takes a pretty while to copy the physical files though. In this case, I dont really see the point to detach/attach the database? Instead, backup/restore may be faster? (also, as detach the database, the files has to be taken offline)

Just confused about the way we trasfer database files with detach/attach. I am looking forward to hearing from you shortly for any advices for that.

With best regards,

Yours sincerely,

When you detach/attach a database, you are physically moving the target database. So, you are taking the database "offline" and moving it to a new location. You are not going to get away from the time it takes to move/create files...you are going to incur that overhead in attaching or restoring. When you backup/restore the database, you incur the time it takes to create the backup file, move it if you need to, and restore it. The database stays online, which may be what you need, but you will likely find that it takes much, much more time to backup and restore a db than it takes to detach/attach.
Tim|||

Hi, thanks a lot for your kind advices.

In my case, I just found that detach/attach did not really save much time for me compared to backup/restore. That's the reason why I asked this question. Maybe we will see the effect for very large database with a certain degree of size? Thanks.

With best regards,

Yours sincerely,

Question on derived column expression

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on derived column expression. The expression I am trying to use for the derived column is as below (column1 is a numeric data type column):

case

when column1<0 then 'yes'

else 'no'

end

But I got the error message though, would please any experts here give me any advices on the expression I used? What is wrong with the expression I used above?

Thank you very much and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

column1 < 0 ? "yes" : "no"

That's the correct format for SSIS expressions.|||

What error message are you getting, and where exactly are you trying to do this? If it is in an Execute SQL task or and OLE DB source, that syntax should work. If it is in the Derived Column transform, you need to use something like (freehanding):

Code Snippet

[column1] < 0 ? "yes", "no"

|||

Hi, Phil,

Thanks a lot and would you please kindly advise me if there is any SSIS expression reference?

With best regards,

Yours sincerely,

|||

Helen999888 wrote:

Hi, Phil,

Thanks a lot and would you please kindly advise me if there is any SSIS expression reference?

With best regards,

Yours sincerely,

You can search around here a bit to find examples and such, but you can use Books Online. SSIS expressions are derived from C/C++.

http://msdn2.microsoft.com/en-us/library/ms140206.aspx|||

Hi, Jwelch,

Thank you, yes, the expression i used was in the derived column transform.

Where could I actually find the SSIS expression reference?

Thanks and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

|||Both of the currently available books on SSIS (Professional SQL Server Integration Services and Microsoft SQL Server Integration Services) include information on expressions.|||

Hi, Jwelch,

Thanks a lot.

With best regards,

Yours sincerely,

Question on data source and data source view of MOLAP cube

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the data source and data source view of MOLAP Cube. As we know MOLAP Cube stores all data in MOLAP format, it does not have any thing to do with its source data base. As a result, I am wondering if we could actually remove the data source and data source view of the MOLAP cube? (in my case, no update is necessary to be informed from the underlying data source to the MOLAP cube)

Hope it is clear for your help.

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

With best regards,

Yours sincerely,

Hello again Helen.

You will always need a data source and a data source view for the cube.

What you can do, in order to create an off-line cube is to use local cubes, if this is the scenario you are thinking about?

With local cubes you create a local cube file that you can put on a laptop and analyze data without being connected to SSAS2005.

Both ProClarity and Excel2007 have this option.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your very kind advices.

But I found that change of the data source view does not really reflect on the data source view of the cube though? I mean after I created the cube, and I edited the data source view, but when I clicked on the cube, its data source view remained as the one before I changed to the new data source view?

Also, I am a bit confused, as all the data for the cube has already stored in SSAS2005 Data base (MOLAP), so why we still need to care about the data source and data source view if we dont need to have any update from the underlying data source?

Thank you for your kind attention and I am looking forward to hearing from you shortly for your further advices.

With best regards,

Yours sincerely,

|||

Hi, Helen.

I am not sure about the scenario here? Do you mean that you will create the cube once and never process it again?

If new dimension records and new fact records arrives from the data source you will always need to process the cube. If you need to process you will need to have the data source view.

During a days work new transactions will be registered in the source system. You will have to do a new process of the cube in order to get them from the source system into the cube.

Are you making cubes for laptop users that they will use off-line? Or are you building cubes using real time OLAP?

Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your reply. In my case, well, I do deploy the whole project containing the cube after I changed the data source and data source view, but the cube remains the same as before I did any change. Therefore, I thought data source and data source view does not have anything to do with the MOLAP cube after its first deployment to the analysis services server.

Does it work in this way? Or I miss out anything of it? Thank you and your advices are most welcome.

With best regards,

Yours sincerely,

|||

Hello Helen. If you make a change like adding an attribute in the data source (source table/view) or the data source view(=named calculation) this change will not be a part of the cube until you add the attribute in the dimension editor.

In order to make a change in a cube you must mapp new columns to the measure group or to the dimension in the cube/dimension editor.

The data source view do not automatically update the cube or the dimensions. If you do a refresh in the data source view(right click) all changes in the source database will exported to the data source view.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot for your kind advices.

It cleared my confusion over the above question.

Thanks again.

With best regards,

Yours sincerely,

Question on data source and data source view of MOLAP cube

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the data source and data source view of MOLAP Cube. As we know MOLAP Cube stores all data in MOLAP format, it does not have any thing to do with its source data base. As a result, I am wondering if we could actually remove the data source and data source view of the MOLAP cube? (in my case, no update is necessary to be informed from the underlying data source to the MOLAP cube)

Hope it is clear for your help.

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

With best regards,

Yours sincerely,

Hello again Helen.

You will always need a data source and a data source view for the cube.

What you can do, in order to create an off-line cube is to use local cubes, if this is the scenario you are thinking about?

With local cubes you create a local cube file that you can put on a laptop and analyze data without being connected to SSAS2005.

Both ProClarity and Excel2007 have this option.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your very kind advices.

But I found that change of the data source view does not really reflect on the data source view of the cube though? I mean after I created the cube, and I edited the data source view, but when I clicked on the cube, its data source view remained as the one before I changed to the new data source view?

Also, I am a bit confused, as all the data for the cube has already stored in SSAS2005 Data base (MOLAP), so why we still need to care about the data source and data source view if we dont need to have any update from the underlying data source?

Thank you for your kind attention and I am looking forward to hearing from you shortly for your further advices.

With best regards,

Yours sincerely,

|||

Hi, Helen.

I am not sure about the scenario here? Do you mean that you will create the cube once and never process it again?

If new dimension records and new fact records arrives from the data source you will always need to process the cube. If you need to process you will need to have the data source view.

During a days work new transactions will be registered in the source system. You will have to do a new process of the cube in order to get them from the source system into the cube.

Are you making cubes for laptop users that they will use off-line? Or are you building cubes using real time OLAP?

Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your reply. In my case, well, I do deploy the whole project containing the cube after I changed the data source and data source view, but the cube remains the same as before I did any change. Therefore, I thought data source and data source view does not have anything to do with the MOLAP cube after its first deployment to the analysis services server.

Does it work in this way? Or I miss out anything of it? Thank you and your advices are most welcome.

With best regards,

Yours sincerely,

|||

Hello Helen. If you make a change like adding an attribute in the data source (source table/view) or the data source view(=named calculation) this change will not be a part of the cube until you add the attribute in the dimension editor.

In order to make a change in a cube you must mapp new columns to the measure group or to the dimension in the cube/dimension editor.

The data source view do not automatically update the cube or the dimensions. If you do a refresh in the data source view(right click) all changes in the source database will exported to the data source view.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot for your kind advices.

It cleared my confusion over the above question.

Thanks again.

With best regards,

Yours sincerely,

Question on Data Mining add-in for Office Visio 2007

Hi, all experts here,

Thank you for your kind attention.

Data mining add-in for Office Visio 2007 is great. But what I am concerning is-to end users (to technical users) how could we deliver the data mining models results in a better way (e.g. integrate with other possible clients ) to make it dynamically and easily undertood?

Hope my question is clear for your help.

With best regards,

Yours sincerely,

Not sure what you are looking for. We do have the thin client viewers for tree models and NB/Clustering which are interactive. Using Visio you can save as a web page which provides some interactivity|||

Hi, Jamie,

Thanks a lot for your help.

With best regards,

Yours sincerely,

Question on Cube storage location

Hi, all experts here,

Thank you for your kind attention.

Why when I selected the storage location for any partition of a cube, only the local system drive is available for options? Is there any way to choose other storage locations rather than the local system drive as the storage location of the cube?

Thanks a lot in advance for your advices and I am looking forwad to hearing from you shortly.

With best regards,

Yours sincerely,

Hi,

The server property AllowedBrowsingFolders specifies the list of folders (separated by the '|' character) available to the browsing dialog used to enter the storage location of a partition (you can edit that property in the server's properties dialog from SQL Management Studio - you need to check the 'Show Advanced Properties' checkbox).

You can only put local folders in the AllowedBrowsingFolders property (so no shares, even from the same machine).

Adrian Dumitrascu

|||

Hi, Adrian,

Thank you very much for your kind advices.

With best regards,

Yours sincerely,