Do SQL Analysis service needs a separate database ?

As Adventure Works have Adventure works DW as a separate database, Do we also needs to create new database such as while working with "pubs" or any other do we need to create pubs DW separately or pubs will be sufficient for our working for sql analysis ?

Hi,

you should to create a new DW database (it′s a best pratice), but it′s not mandatory.

If you have a small production database, you will not percept the performance degradation...

So to create a DW (Dataware house) can be good to isolate OLAP from OLTP.

Regards

Do I need to reinstall analysis services after we upgraded sqlserv

Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
from stanadard edition to enterprise edition? The developer tried to use
partition on analysis service and message from analysis manager showed that
it is not aware that our sqlserver has been upgraded to enterprise edition
already. "user-defined partitions are available only if you installed
analysis services on enterprise edition".
May be the problem is caused by the meta data repository? If we migrate the
repository to SQL server, the problem will be resolved?
"sabby" wrote:

> Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
> from stanadard edition to enterprise edition? The developer tried to use
> partition on analysis service and message from analysis manager showed that
> it is not aware that our sqlserver has been upgraded to enterprise edition
> already. "user-defined partitions are available only if you installed
> analysis services on enterprise edition".

Do I need to reinstall analysis services after we upgraded sqlserv

Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
from stanadard edition to enterprise edition? The developer tried to use
partition on analysis service and message from analysis manager showed that
it is not aware that our sqlserver has been upgraded to enterprise edition
already. "user-defined partitions are available only if you installed
analysis services on enterprise edition".May be the problem is caused by the meta data repository? If we migrate the
repository to SQL server, the problem will be resolved?
"sabby" wrote:

> Do I need to reinstall/upgrade analysis services after we upgraded sqlserv
er
> from stanadard edition to enterprise edition? The developer tried to use
> partition on analysis service and message from analysis manager showed tha
t
> it is not aware that our sqlserver has been upgraded to enterprise edition
> already. "user-defined partitions are available only if you installed
> analysis services on enterprise edition".

Do I need to reinstall analysis services after we upgraded sqlserv

Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
from stanadard edition to enterprise edition? The developer tried to use
partition on analysis service and message from analysis manager showed that
it is not aware that our sqlserver has been upgraded to enterprise edition
already. "user-defined partitions are available only if you installed
analysis services on enterprise edition".May be the problem is caused by the meta data repository? If we migrate the
repository to SQL server, the problem will be resolved?
"sabby" wrote:
> Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
> from stanadard edition to enterprise edition? The developer tried to use
> partition on analysis service and message from analysis manager showed that
> it is not aware that our sqlserver has been upgraded to enterprise edition
> already. "user-defined partitions are available only if you installed
> analysis services on enterprise edition".

Do I need SSIS to process cube?

There is a function called "proactive caching" in Analysis services. It can:
-Automatic synchronization with the relational database
-No more explicit "cube processing

But I cannot have the latest data in the cube even I set the proactive mode as "real time"

Do I need SSIS to process cube in this case?

Following is the procedures I have done:
1. test the data
1.1 use the bi dev studio to browser the cube, ensure no new data are there
1.2 process the the cube and browser the data, ensure new data are there
1.3 delete new data from source database and reprocess the cube, ensure no new data are there
1.4 add new data again

2. configure the proactive setting of cube
2.1 use sql server management studio to open the cube and open the properties window
2.2 in the option of "proactive caching" select "low-latency MOLAP" (even real-time ROLAP later), then click ok

3. configure the proactive setting of cube
3.1 open the patitions view properties window

3.2 in the option of "proactive caching" select "low-latency MOLAP" (even real-time ROLAP later), then click ok

3.3 in the notification tab, select "sql server " and specifiy tracking tables to the "fact table", which is a view to get data from real fact table.

4. wait a period of time...

5. test the data again
5.1 use the bi dev studio to browser the cube, but no new data are there (even I selected real-time ROLAP later). I even tried the reconnect and refresh options in the tool bar

So my questions are :
1. Did I do the right thing to achieve the target "Automatic synchronization with the relational database "

2. Can I monitor the procedure of synchronization, such as monitoring the log of processing, viewing the schedule setting and status of the process?



Thanks a lot!

You'd be better putting this on the SSAS forum.

-Jamie

|||

Sorry to post to the wrong place. But I did post it to the SSAS yesterday but nobody answered. Since it is urgent for me to solve the problem, I tried to post here.

I just wanted to know whether I should use "proactive caching" or use SSIS to solve the problem. Even a simple answer yes or no will be mostly appreciated.

Thanks!

|||

Well it depends on your requirements.

Using ProActive caching means there is an unknown latency between putting data into the warehouse and it appearing in the cube. But the good thing is you don't have to build extra functionality to do it.

The opposite is true of using SSIS. You process the cube when you need it to but you have to build, maintain and control that extra fucntionality.

Its your choice.

-Jamie

|||

Thanks Jamie.

That means I can use proactive caching to synchronize the data from database? Now the problem is how to make it work. At least I think I am in the right track.So I will put more time on it.

Thanks again.

|||

Sorry, I still cannot work it out. Can anybody help?

Thanks in advance!

Do Analysis service needs a seprate Database ?

As Adventure Works have Adventure works DW, Do we also needs to create new database such as while working with pubs do we need to create pubs DW separately or pubs will be sufficient for our working ?

for sure not.

But it is a good design aproach.

You could do a seperate BI database, or

create your own tables in the exiting database, or

create views in the existing database or

use the Analysis Services Datasource View with Named querys

to do the data transformation

HANNES

DMX Tutorials for AdventureWorks

Can anybody help me find a comprehensive tutorial on DMX executed against the AdventureWorks database on Analysis Services on SQL Server 2005?We don't have a dedicated DMX tutorial available currently but the DMX reference in Books Online as well as the Tips & Tricks section at www.sqlserverdatamining.com would be good resources to start with.

DMX from Java

My preferred programming language is Java (sorry Microsoft). I've searched for examples of running DMX queries into an Analysis Services database from Java but failed to locate any. I've seen suggestions that XMLA could be used but again, I can't locate any examples (in any language). For my current project I ran up the white flag and used C# instead but this wouldn't be an option in other cases. It would be possible to make the DMX calls from C# objects and call those from Java but that's pretty labourious to code.

Suggestions?

have you tried the XMLA Thin Client sample at http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/124.aspx ?

|||I found that page but I didn't find any code sample to go with it.|||There's an old(er) code sample here http://www.sqlserverdatamining.com/DMCommunity/SQLServer2000/Links_LinkRedirector.aspx?id=96

DMQL

DMQL use for query data mining ?

how can i use it ? ( i'm using Analysis services 2000).

can you give me an example.

thanks

For SQL 2000 check out the DMSample Query tool and DMX Query Samples at

http://www.sqlserverdatamining.com/DMCommunity/SQLServer2000/default.aspx