Profiler

Hey,
I want to run the profiler in certain times during the
day. Instead of me opening and closing sessions of
profiler, i extracted the script and run it through query
analyser (then schedula it as a job and run at the times i
want). I am testing this now and there seems to be a
problem. I run the script i got and when i execute it in
query anaylser the profiler file is created in the
location i want but no data is being written to it. I
cannot delete it because "the file is being used"... does
anyone know why this happenes? any work arrounds?
Help please!!Hi Claudia
This is normal.
Data is only written to the trace file in 128K chunks. So as soon as there
is 128K worth of events, you'll see some size for the file. If you stop and
close the trace, it will also write all the remaining data to the trace
file, or if the server is stopped.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Claudia" <anonymous@.discussions.microsoft.com> wrote in message
news:03dd01c39954$e85764d0$a001280a@.phx.gbl...
> Hey,
> I want to run the profiler in certain times during the
> day. Instead of me opening and closing sessions of
> profiler, i extracted the script and run it through query
> analyser (then schedula it as a job and run at the times i
> want). I am testing this now and there seems to be a
> problem. I run the script i got and when i execute it in
> query anaylser the profiler file is created in the
> location i want but no data is being written to it. I
> cannot delete it because "the file is being used"... does
> anyone know why this happenes? any work arrounds?
> Help please!!sql

Production Report against OLAP database

We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated."Atul Mehta" <amehta@.oaktreecap.com> schrieb im Newsbeitrag
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.

---

Atul, you don't necessarily need another Reporting Tool. You need to decide
where you want to build your -> Data Warehouse or -> Data Mart in.
Regards,
Joerg|||If you're looking for cheap and easy, office web components (pivot tables),
or cheap and tedious: ASP web pages and PTS. You might want to see if MSFT
Reporting Services is a potential solution for you.
Another option is to build a star schema reporting database, which will be
useful for building cubes as well, but may eliminate the need.
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.
>
>
>

---

ProClarity: Is there any way we can use tables as sources of ProClarity views instead of cubes?

Is there any way we can use tables as sources of ProClarity views instead of cubes?

Hello! It is not possible. ProClarity is a SSAS-tool only.

You must build a cube in order to use ProClarity.

HTH

Thomas Ivarsson

sql

Process Cube using Integration Services

Hi,

I want to process my cube using Process Data and Process Index instead of the Process Full. However, after configuring the 2 Analysis Services Processing Tasks (one for process data and the other for process index) and were executed sequentially (process data first then process index), I got this error:

Errors in the metadata manager. The process type specified for the CASES cube is not valid since it is not processed

Have I done the right thing?

The reason why I prefer using the Process Data and then Process Index, it's because it is much faster than the latter.

cherriesh

It's interesting that you're seeing an error, because 'Process Full' is nothing more than 'Process Data' and then 'Process Index' under the covers.

I'll admit that I was skeptical that executing the two sequentially was faster for you than process full, but I found an Analysis Services best practices whitepaper that confirmed this could happen.

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx

Are you sure you are using 'Process Data' on the cube object itself and not a measure group or partition?

Also, you may want to post this question in the Analysis Services forum.

|||

Hi,

I did the process data for both the dimensions and cube. and did also process index for the two.

am i right there?

cherriesh

|||

I think that might be your issue. If it processes a dimension after the cube that would explain the error message you received on the step to process the index. Try doing process data for just the cube (it should do the dimensions as part of this).

Process Cube

Hi,

I want to process my cube using Process Data and Process Index instead of the Process Full. However, after configuring the 2 Analysis Services Processing Tasks (one for process data and the other for process index) and were executed sequentially (process data first then process index), I got this error:

Errors in the metadata manager. The process type specified for the CASES cube is not valid since it is not processed

Have I done the right thing?

The reason why I prefer using the Process Data and then Process Index, it's because it is much faster than the latter.

I'm not sure though what Process Index is for. As far as I'm concerned, I have done partitions (I used performance gains reaches ) but I don't remember to explicitly declare indexes.

Please help...

cherriesh

Hi,

In theory what you did to me seems as if it should work. Have you tried doing it outside SSIS? So in managment studio, process data and then index, might be a problem with the cube not actually processing the data step properly.

but here is a description of what the different process types do

http://technet.microsoft.com/en-us/library/ms174774.aspx

Hope that helps

Matt

|||

Hi,

The ProcessFull is working fine. I dunno how to do this outside SSIS. Am I right to have Process Data for both Dimension and Cube and to have another Analysis Services Process Task for Process Index for both (Dimension and cube)

cherriesh

|||

Hi,

I found a better link:

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

For the dimensions:

A process full will reprocess the dimension completely

Never done a process index on a dimension, but i would assume process data then process index.

Once the dimensions are processed then process the cube

Process Full

Process data and process index (two seperate tasks I am guessing)

You could try

(task 1) Is to process the structure of the cube (processes all the dimensions)

(task 2) Process full of cube

OR

task 1, process data of dims

task 2, process indexes

task 3, process data of cube

task 4, process indexes of cube

OR

task 1, process structure of cube

task 2, process data of cube

task 3, process indexes of cube

Sure there are lots of different ways.

With reference to aleternative ways of processing:

http://technet.microsoft.com/en-us/library/aa337509.aspx

Hope that helps,

Matt