Link analysis

Does Microsoft plan to extend the number of Data Mining algorithms in AS in the future releases? The question is motivated by the task of so called "link analysis" where one should determine how data attributes are related to each other or how and in what extent they influence each other in probabilistic terms. A good solution would be to build a Bayesian Network which gives an insight to how data attributes are related by means of directed acyclic graph. But this approach is not yet implemented in AS2005.

Existing algorithms such as association rules or decision trees might be used but they are far from being ideal for this task (association rules are designed for determining frequent boolean sets in data like Name=Attribute, decision trees work good for classification tasks but perform poor by design for the tasks of revealing attributes direct and inderect influence).

It would be interesting to know what algorithms and approaches Microsoft plans to develop in the future.

We cannot comment on algorithms that will appear in future versoins other than what has already been announced. In SQL Server 2008 we are introducing ARIMA time series with a default option to combine both ARTXP and ARIMA models to get the best of both approached.

The July CTP of SQL Server 2008 has this algorithm available.

Link analysis

Does Microsoft plan to extend the number of Data Mining algorithms in AS in the future releases? The question is motivated by the task of so called "link analysis" where one should determine how data attributes are related to each other or how and in what extent they influence each other in probabilistic terms. A good solution would be to build a Bayesian Network which gives an insight to how data attributes are related by means of directed acyclic graph. But this approach is not yet implemented in AS2005.

Existing algorithms such as association rules or decision trees might be used but they are far from being ideal for this task (association rules are designed for determining frequent boolean sets in data like Name=Attribute, decision trees work good for classification tasks but perform poor by design for the tasks of revealing attributes direct and inderect influence).

It would be interesting to know what algorithms and approaches Microsoft plans to develop in the future.

We cannot comment on algorithms that will appear in future versoins other than what has already been announced. In SQL Server 2008 we are introducing ARIMA time series with a default option to combine both ARTXP and ARIMA models to get the best of both approached.

The July CTP of SQL Server 2008 has this algorithm available.

sql

Linear equations?

Is there a way to solve a system of linear equations in Analysis Services?
Let's say I have a table with two columns for all the coefficients:
C12 - 0.30
C13 - 0.70
C21 - 0.15
C23 - 0.10
....
Is there something in Analysis Services that can do this?Can you give a bit more detail on what you are trying to achieve?|||I am trying to calculate cost allocations for budgeting, based on internal costs and a grid of distribution percentages. It comes down to solving a system of linear equations. It would have been great if I can create a report where this system is solved internally everytime the report is run.|||

There are a set of MDX functions for handling linear regression problems. It should be possible for you to use them to define one or more calculated members that take the output of one or more of the functions and calculate the cost allocations. If you look in Books Online at the MDX functions list, you'll see LinRegIntercept, LinRegPoint, LinRegSlope, LinRegVariance, and LinRegR2...

Dave Fackler

|||

And if you want to see an example of how these LinReg functions can be applied - you can check the following article: http://www.mosha.com/msolap/articles/mdxlinreg.htm

Limiting access to Report Designer Only

Hi,
Has anyone tried to limit access to Report Designer only? We have report
developers that can't have access to Integration Services, Analysis Services,
Report Models, etc. What files or directories can we remove to limit their
access?
Thanks for your help!You do not need to run reporting services to design report with VS.NET. That
is, you can cut all your report developers' access to your reporting
services, they still can design report on their own computer, as long as
report designer is installed along with VS.NET and they have data source to
test it (of coourse they cannot test deployment).
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> Hi,
> Has anyone tried to limit access to Report Designer only? We have report
> developers that can't have access to Integration Services, Analysis
> Services,
> Report Models, etc. What files or directories can we remove to limit their
> access?
> Thanks for your help!|||Thanks for the reply. We've installed vs.net 2005 but don't see report
designer. How do you install it? Is there a snap-in or plug-in for Report
Designer?
Thanks!
"Norman Yuan" wrote:
> You do not need to run reporting services to design report with VS.NET. That
> is, you can cut all your report developers' access to your reporting
> services, they still can design report on their own computer, as long as
> report designer is installed along with VS.NET and they have data source to
> test it (of coourse they cannot test deployment).
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> > Hi,
> >
> > Has anyone tried to limit access to Report Designer only? We have report
> > developers that can't have access to Integration Services, Analysis
> > Services,
> > Report Models, etc. What files or directories can we remove to limit their
> > access?
> >
> > Thanks for your help!
>
>|||Hi Norman, we have the same issue. It seems that VS 2005 does not ship with
report designer. Can it be downloaded seperately?
"Norman Yuan" wrote:
> You do not need to run reporting services to design report with VS.NET. That
> is, you can cut all your report developers' access to your reporting
> services, they still can design report on their own computer, as long as
> report designer is installed along with VS.NET and they have data source to
> test it (of coourse they cannot test deployment).
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> > Hi,
> >
> > Has anyone tried to limit access to Report Designer only? We have report
> > developers that can't have access to Integration Services, Analysis
> > Services,
> > Report Models, etc. What files or directories can we remove to limit their
> > access?
> >
> > Thanks for your help!
>
>|||Install the client tools from RS 2005. It no longer requires having VS. It
comes with it's own VS that gets installed if you don't have it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in message
news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
> Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> with
> report designer. Can it be downloaded seperately?
> "Norman Yuan" wrote:
>> You do not need to run reporting services to design report with VS.NET.
>> That
>> is, you can cut all your report developers' access to your reporting
>> services, they still can design report on their own computer, as long as
>> report designer is installed along with VS.NET and they have data source
>> to
>> test it (of coourse they cannot test deployment).
>> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
>> > Hi,
>> >
>> > Has anyone tried to limit access to Report Designer only? We have
>> > report
>> > developers that can't have access to Integration Services, Analysis
>> > Services,
>> > Report Models, etc. What files or directories can we remove to limit
>> > their
>> > access?
>> >
>> > Thanks for your help!
>>|||Hi Bruce,
We have installed the client tools from RS 2005 using the sql server 2005
release C2 disk. The problem is we need to be able to limit access to only
use Report Designer for certain developers. We don't want certain developers
to be able to use certain features such as SSIS, Analysis Services, Report
model designer, etc. Make sense? Is there a separate install for RS 2005
client tools?
Thanks for your help!
"Bruce L-C [MVP]" wrote:
> Install the client tools from RS 2005. It no longer requires having VS. It
> comes with it's own VS that gets installed if you don't have it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in message
> news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
> > Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> > with
> > report designer. Can it be downloaded seperately?
> >
> > "Norman Yuan" wrote:
> >
> >> You do not need to run reporting services to design report with VS.NET.
> >> That
> >> is, you can cut all your report developers' access to your reporting
> >> services, they still can design report on their own computer, as long as
> >> report designer is installed along with VS.NET and they have data source
> >> to
> >> test it (of coourse they cannot test deployment).
> >>
> >> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> >> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> >> > Hi,
> >> >
> >> > Has anyone tried to limit access to Report Designer only? We have
> >> > report
> >> > developers that can't have access to Integration Services, Analysis
> >> > Services,
> >> > Report Models, etc. What files or directories can we remove to limit
> >> > their
> >> > access?
> >> >
> >> > Thanks for your help!
> >>
> >>
> >>
>
>|||What you can do is they can develop but they cannot deploy. That is easy.
Also you can manage rights to the database which would determine what they
can do. Not sure about Report model designer. I don't know much about that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:0E6CFB95-93CB-4537-989C-0E13C37A7228@.microsoft.com...
> Hi Bruce,
> We have installed the client tools from RS 2005 using the sql server 2005
> release C2 disk. The problem is we need to be able to limit access to only
> use Report Designer for certain developers. We don't want certain
> developers
> to be able to use certain features such as SSIS, Analysis Services, Report
> model designer, etc. Make sense? Is there a separate install for RS 2005
> client tools?
> Thanks for your help!
> "Bruce L-C [MVP]" wrote:
>> Install the client tools from RS 2005. It no longer requires having VS.
>> It
>> comes with it's own VS that gets installed if you don't have it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in
>> message
>> news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
>> > Hi Norman, we have the same issue. It seems that VS 2005 does not ship
>> > with
>> > report designer. Can it be downloaded seperately?
>> >
>> > "Norman Yuan" wrote:
>> >
>> >> You do not need to run reporting services to design report with
>> >> VS.NET.
>> >> That
>> >> is, you can cut all your report developers' access to your reporting
>> >> services, they still can design report on their own computer, as long
>> >> as
>> >> report designer is installed along with VS.NET and they have data
>> >> source
>> >> to
>> >> test it (of coourse they cannot test deployment).
>> >>
>> >> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> >> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > Has anyone tried to limit access to Report Designer only? We have
>> >> > report
>> >> > developers that can't have access to Integration Services, Analysis
>> >> > Services,
>> >> > Report Models, etc. What files or directories can we remove to limit
>> >> > their
>> >> > access?
>> >> >
>> >> > Thanks for your help!
>> >>
>> >>
>> >>
>>

Limitation of # cubes inside a base Analysis Services

Does anyone

have any idea which is the limitation of # cubes inside a base Analysis Services,

because I created 50 cubes, and when I tried to connect to the base, i was

enable to do that because the CPU was at

100 %.

I think

that is a problem when analysis services tried to read the xmla and print all the cubes.

Tks

Well. There is a point where number of cubes and size of your data requre you to go and get a bigger machine.

It would be wrong to assume you can create any number of cubes and expect from Analysis Services not to use more CPU or memory trying to handle them all. The question what is reasonable. If you think that you got poweful machine with multiple processors and fast I/O and you see Analysis Services cannot handle large number of objects, there could be somehting. As a reference you can use Project REAL that handle large number of objects. http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hallo Calacean,

the problem, you have accounted is not a SSAS with its limitations, but the client you use.

Some clients read copletely all metadata (available cubes, dimensins, hierarhies, levels, measures etc.) immediately after connection to the database.

Take a time to monitor with the SQL Profiler what commands and queries are sent from your client to the sever. You do find some interesting for you.

|||

Thanks, is

very useful, but i have another question if i don't bother you.

I have a data warehouse with 50 mil. dates. And i have 6 measures group with

relations many 2 many. When i query the cube, first is very slow( and i design aggregations

for all the measures), and second (I have proactive caching setup), when i want to

modify some data from the tables of proactive caching , the proactive caching

is working very god, but it decrease very much the performance of the server,

and the performance of the applications. I forget to mention that I have P4

2Ghz(2CPU), 2GB Memory, and I run Sql Server 2005 and Analysis Services in the

same server.

Limit to number of databases in Analysis Services 2005

We are trying to run a load test on analysis services 2005. We were
going to start with 30 different databases out there and see what the
processing loads were. Analysis Services is stopping us at 25
databases and telling us that there is no more room. We have 260 GB
free on the server. Has anyone run into this before? Is there a limit
to the number of databases you can have? Does it vary by SQL edition?http://msdn2.microsoft.com/en-us/library/ms365363.aspx
<rbergstrom@.spectrumhr.com> wrote in message
news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> We are trying to run a load test on analysis services 2005. We were
> going to start with 30 different databases out there and see what the
> processing loads were. Analysis Services is stopping us at 25
> databases and telling us that there is no more room. We have 260 GB
> free on the server. Has anyone run into this before? Is there a limit
> to the number of databases you can have? Does it vary by SQL edition?
>|||Thanks for that link. Now I will ask a dumb question. in the page on
that link it shows Maximum sizes/numbers. The value for Databases in
an instance is 2^31-1 = 2,147,483,647. Is that a total size in bytes?
The number of databases? I don't understand what that is supposed to
represent. Thanks for your help.
Immy wrote:
> http://msdn2.microsoft.com/en-us/library/ms365363.aspx
> <rbergstrom@.spectrumhr.com> wrote in message
> news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> > We are trying to run a load test on analysis services 2005. We were
> > going to start with 30 different databases out there and see what the
> > processing loads were. Analysis Services is stopping us at 25
> > databases and telling us that there is no more room. We have 260 GB
> > free on the server. Has anyone run into this before? Is there a limit
> > to the number of databases you can have? Does it vary by SQL edition?
> >

Limit to number of databases in Analysis Services 2005

We are trying to run a load test on analysis services 2005. We were
going to start with 30 different databases out there and see what the
processing loads were. Analysis Services is stopping us at 25
databases and telling us that there is no more room. We have 260 GB
free on the server. Has anyone run into this before? Is there a limit
to the number of databases you can have? Does it vary by SQL edition?http://msdn2.microsoft.com/en-us/library/ms365363.aspx
<rbergstrom@.spectrumhr.com> wrote in message
news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> We are trying to run a load test on analysis services 2005. We were
> going to start with 30 different databases out there and see what the
> processing loads were. Analysis Services is stopping us at 25
> databases and telling us that there is no more room. We have 260 GB
> free on the server. Has anyone run into this before? Is there a limit
> to the number of databases you can have? Does it vary by SQL edition?
>|||Thanks for that link. Now I will ask a dumb question. in the page on
that link it shows Maximum sizes/numbers. The value for Databases in
an instance is 2^31-1 = 2,147,483,647. Is that a total size in bytes?
The number of databases? I don't understand what that is supposed to
represent. Thanks for your help.
Immy wrote:[vbcol=seagreen]
> http://msdn2.microsoft.com/en-us/library/ms365363.aspx
> <rbergstrom@.spectrumhr.com> wrote in message
> news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...