Showing posts with label olap. Show all posts
Showing posts with label olap. Show all posts

Wednesday, March 21, 2012

Reports with OLAP Cubes

Hi

I try to design a report with Chart based on an Analysis Services Data source...

It does'nt work !!!

Has anyone else the same problem?

It would help if you could provide more details of what exactly does not work.


Maybe the data values are coming across as strings rather than numeric values? Try to convert the datatype for the datapoint expressions. E.g. =Sum(CDbl(Fields!Measure.Value))

-- Robert

|||

Hi,

I have a OLAP report with a table. I need to display a chart on click of particular cell in the table wihtin the same report. How to pass the parameter from the table to the chart and display it in the same report? Pls help me in solving this

Reports with OLAP Cubes

Hi

I try to design a report with Chart based on an Analysis Services Data source...

It does'nt work !!!

Has anyone else the same problem?

It would help if you could provide more details of what exactly does not work.


Maybe the data values are coming across as strings rather than numeric values? Try to convert the datatype for the datapoint expressions. E.g. =Sum(CDbl(Fields!Measure.Value))

-- Robert

|||

Hi,

I have a OLAP report with a table. I need to display a chart on click of particular cell in the table wihtin the same report. How to pass the parameter from the table to the chart and display it in the same report? Pls help me in solving this

Reports with "Multi Parameters" Accessing Analysis Services Cube (MDX calls)?

I have an OLAP Cube that is being accessed by Reporting services reports
with MDX syntax. I am successful so far in having one parameter set. I need
to know if it is possible to have more than one to set and get the desired
results accordingly. Here is what I have so far:
Data Source:
="Select NON EMPTY{ {[Geo1].[Div].members}*{[Dept1].[Department].members}*
{ [Employee].[All Employee].children}} On ROWS,
NON EMPTY {[Measures].[Percent Complete]} ON COLUMNS
FROM [My Cube1]
WHERE ([" + Parameters!pCurr.Value + "])"
pCurr data set :
SELECT { [Measures].[Percent Complete]} ON Columns,NON EMPTY [Curriculum].
[Curriculum].Members ON ROWS FROM [My Cube1]
So, thus Far I can control the result set by Choosing the Curriculum only.
I need to be able to have another parameter set, besides Curriculum, for
instance Department, where I would choose department, then curriculum,
then the result set would be the outcome needed? Is it feasible and how?
Thanks so much in advance.
--
Message posted via http://www.sqlmonster.com="SELECT NON EMPTY { {[Geo1].[Div].members } * {[Dept1].[Department].[" +
Parameters!pDept.Value + "] } * { [Employee].[All Employee].children}} On
ROWS,
NON EMPTY {[Measures].[Percent Complete]} ON COLUMNS
FROM [My Cube1]
WHERE ([" + Parameters!pCurr.Value + "])"
btw, i usually don't use the where clause, i just put parameter into the
select dimensions.
"Hobie via SQLMonster.com" wrote:
> I have an OLAP Cube that is being accessed by Reporting services reports
> with MDX syntax. I am successful so far in having one parameter set. I need
> to know if it is possible to have more than one to set and get the desired
> results accordingly. Here is what I have so far:
> Data Source:
> ="Select NON EMPTY{ {[Geo1].[Div].members}*{[Dept1].[Department].members}*
> { [Employee].[All Employee].children}} On ROWS,
> NON EMPTY {[Measures].[Percent Complete]} ON COLUMNS
> FROM [My Cube1]
> WHERE ([" + Parameters!pCurr.Value + "])"
> pCurr data set :
> SELECT { [Measures].[Percent Complete]} ON Columns,NON EMPTY [Curriculum].
> [Curriculum].Members ON ROWS FROM [My Cube1]
> So, thus Far I can control the result set by Choosing the Curriculum only.
> I need to be able to have another parameter set, besides Curriculum, for
> instance Department, where I would choose department, then curriculum,
> then the result set would be the outcome needed? Is it feasible and how?
> Thanks so much in advance.
> --
> Message posted via http://www.sqlmonster.com
>|||Great. it worked with few glitches that I am working on correcting.
However, I do not want to include my parameters in the select. see I would
like the below format:
Select Select Select
Division: Services Department:Acounting Curriculum: Excel (as params)
_________________________________________________________________
Employee Percent Complete
John 40%
Amy 20%
Kerry 90%
That is why I was adding the where clause. If I can say in the WHERE:
WHERE ([" + Parameters!pDiv.Value + "] AND [" + Parameters!pDept.Value + "]
" AND [" + Parameters!pCurr.Value + "] ),
But I know there is no AND in this fasion in MDX. Any suggestions!
Again thanks in advance for the help!!!
--
Message posted via http://www.sqlmonster.com|||WEll - I solved my own problem, but thanks to mike for the tip; No more
WHERE statement in MDX for params specifications here is what mike
suggested and how I implemented it. :) .
--
DataSource1:
="SELECT NON EMPTY { {[Geo1].[Div].[" + Parameters!pDiv.Value + "]} * {
[Dept1].[Department].[" + Parameters!pDept.Value + "] }*{[Curriculum].
[Curriculum].[" + Parameters!pCurr.Value + "] }*{ [Employee].[All Employee]
.children} } On ROWS, NON EMPTY {[Measures].[Curr Percent Complete]} ON
COLUMNS FROM [CertificationsDB]"
--
DataSet pCurr:
SELECT { [Measures].[Curr percent Complete]} ON Columns,NON EMPTY
[Curriculum].[Curriculum].Members ON ROWS FROM [CertificationsDB]
DataSet pDept:
SELECT { [Measures].[Curr percent Complete]} ON Columns,NON EMPTY [Dept1].
[Department].Members ON ROWS FROM [CertificationsDB]
DataSet pDiv:
SELECT { [Measures].[Curr percent Complete]} ON Columns,NON EMPTY [Geo1].
[Div].Members ON ROWS FROM [CertificationsDB]
Enjoy y'all
--
Message posted via http://www.sqlmonster.comsql

Reports using OLAP fail after 30 minutes without reboot or IIS restart

We are having problems with Reports that Access MSAS. After about
15-30 minutes the reports no longer work and we have to stop and
restart IIS and make one visit to the report manager page. We have to
continue to visit reports or the report manager page every 15 minutes
of we get rsProcessingAborted errors related to a MSAS data source
connection. The environment looks like the following:
Windows Server 2003 SP1
Reports Services SP2
SQL Server SP3
Analysis Services SP3
(everything is on the same box)
The Problem:
After about 30 minutes reports fail with the following error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'VIS_DATAMART'.
(rsErrorOpeningConnection) Get Online Help
The 'MSOLAP.2' provider is not registered on the local machine.
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
We can prevent the above problem with the following hack:
Created an application that visits the report manager url every 15
minutes. So far near as we can tell, that approach prevents the
rsprocessingaborted error. We've also noticed that if our testers
continue to test without 15-30 minutes of in-active time, the site will
continue to work.
I'd like to eliminate this problem and the hack we are relying on. The
problem seems like it is related to caching. Anyone have any thought
or suggestions?Finally found a solution!
I had to create an additional application pool in IIS and move our custom
ASP.NET application to that pool and leave reporting services in the default
pool. After that change the problem went away.

Monday, March 12, 2012

Reports based on OLAP?

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.Is it possible to do that?
--Yes
Are there any client applications which allows to create these types of
reports?
--Yes, you create the cubes in Analysis Services and you can use Excel Pivot
tables to connect, then if you are looking for more functionality and better
graphing capability you have a whole host of options. Search on google for
OLAP viewers, there's a bunch. I use ProClarity (www.proclarity.com )
You will want to look into using DTS to copy your data to a store where you
can build your cubes off.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:u%23ov$HCvDHA.1744@.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.
>

Saturday, February 25, 2012

Reporting SVCS and OLAP

Hello
I have question about OLAP and reporting services, is there any way, or any
add in component for Reporting SVCS, for dynamic olap table. First when i
read feature of Reporting services i read something about integration with
OWC so i was thougt that i can add OWC PivotTable like component on my
Report, but this is not or so....
Is also there any SDK how to buil own component for Reporting Services
thank
Matej
Home page: http://magic.streznik.org
---Hi,
MS Reporting Services is for SQL Reporting and MS Analysis Services is
for MDX Reporting. With the addin of Panorama for MS Reporting
Services it is possible to have a MDX Report in MS Reporting Services
with parameters to choice from a slicer. With a simple click you can
go from static reporting in MS Reporting Services to the webclient of
Panorama for more analysis.
With QuickQuery And ReportBuilder you can make your own SQL Reports in
MS Reporting Services and in future also based on MDX Reports.
You can also use ReportPortal to have all in one concept.
On our website www.gmsbv.nl you will find more info, demos and trials.
Regards,
Marco
www.gmsbv.nl
"Matej Kavèiè" <matej.kavcic@.email.si> wrote in message news:<ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl>...
> Hello
> I have question about OLAP and reporting services, is there any way, or any
> add in component for Reporting SVCS, for dynamic olap table. First when i
> read feature of Reporting services i read something about integration with
> OWC so i was thougt that i can add OWC PivotTable like component on my
> Report, but this is not or so....
> Is also there any SDK how to buil own component for Reporting Services
> thank
> Matej
> Home page: http://magic.streznik.org
> ---|||Ok, there are two independent questions here.
1. OWC:
You might want to checkout MSDN at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
The dynamic pivot table functionality in Reporting Services is done via
Office Web Components (Office XP). Matrix reports (which you can build from
any type of data source) will be rendered as interactive pivot tables in
HTML with OWC.
2. Reporting from Analysis Services:
This question has come up several times on the newsgroup. You might want to
download and check out some samples from this link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
In addition, you may also want to subscribe to this discussion list:
http://groups.msn.com/OLAPServicesDevelopersForum. It should contain a
document in the discussion group under General about approaches how to
directly use Analysis Services 2000 as a datasource for Reporting Services
2000.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matej Kavèiè" <matej.kavcic@.email.si> wrote in message
news:ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hello
> I have question about OLAP and reporting services, is there any way, or
any
> add in component for Reporting SVCS, for dynamic olap table. First when i
> read feature of Reporting services i read something about integration with
> OWC so i was thougt that i can add OWC PivotTable like component on my
> Report, but this is not or so....
> Is also there any SDK how to buil own component for Reporting Services
> thank
> Matej
> Home page: http://magic.streznik.org
> ---
>|||There is also a MSDN article available now: "Integrating Analysis Services
with Reporting Services"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OxSEHJaVEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Ok, there are two independent questions here.
> 1. OWC:
> You might want to checkout MSDN at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
> The dynamic pivot table functionality in Reporting Services is done via
> Office Web Components (Office XP). Matrix reports (which you can build
from
> any type of data source) will be rendered as interactive pivot tables in
> HTML with OWC.
> 2. Reporting from Analysis Services:
> This question has come up several times on the newsgroup. You might want
to
> download and check out some samples from this link:
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
> In addition, you may also want to subscribe to this discussion list:
> http://groups.msn.com/OLAPServicesDevelopersForum. It should contain a
> document in the discussion group under General about approaches how to
> directly use Analysis Services 2000 as a datasource for Reporting Services
> 2000.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Matej Kavèiè" <matej.kavcic@.email.si> wrote in message
> news:ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> > Hello
> >
> > I have question about OLAP and reporting services, is there any way, or
> any
> > add in component for Reporting SVCS, for dynamic olap table. First when
i
> > read feature of Reporting services i read something about integration
with
> > OWC so i was thougt that i can add OWC PivotTable like component on my
> > Report, but this is not or so....
> > Is also there any SDK how to buil own component for Reporting Services
> >
> > thank
> >
> > Matej
> > Home page: http://magic.streznik.org
> > ---
> >
> >
>

Monday, February 20, 2012

Reporting Services without Analysis Services - how to connect to cube?

Hello all.
Right now I'm trying to get a report based on OLAP data to work on a server
which is only running Reporting Services. No Analysis Services have ever
touched this server. So when I try to run my report, I get the following
error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'PB_AxpCmpWR_Project'.
(rsErrorOpeningConnection)
The 'MSOLAP' provider is not registered on the local machine.
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
I guess that it's because some dll's are missing, the msolap.dll and
msolap80.dll. I've figured I need to get these and register them in some
way, but I'm not sure how.
Can I copy these from a different server, and register them manually? Or
will they be installed and registered if I run the PTSFull.exe from the
Analysis Services installation? What is the best way of doing this?
All help appreciated!
Kaisa M. LindahlKaisa M. Lindahl wrote:
> Can I copy these from a different server, and register them manually?
> Or will they be installed and registered if I run the PTSFull.exe
> from the Analysis Services installation? What is the best way of
> doing this?
Installing of ptsfull should solve your problems
frank|||"Frank Matthiesen" <fm@.xax.de> wrote in message
news:3lepd6F12a6brU1@.individual.net...
> Kaisa M. Lindahl wrote:
>> Can I copy these from a different server, and register them manually?
>> Or will they be installed and registered if I run the PTSFull.exe
>> from the Analysis Services installation? What is the best way of
>> doing this?
> Installing of ptsfull should solve your problems
> frank
Thanks. I installed PTSFull.exe and the report is working. I can't find any
good MS articles or notion of this in the Books online, though. It should be
noted somewhere, so it doesn't come as a surprise to someone who installs RS
alone. Or maybe I just didn't look in the right places. Anyone got a link to
an article or something about this?
Kaisa