Showing posts with label build. Show all posts
Showing posts with label build. Show all posts

Monday, March 26, 2012

Reporting Services process Analysis Services cube with 100% load

Hi all,

I use SQL Server 2005 Developer Edition version 9.00.2153 on Windows XP SP2.

I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds.

When I build Reporting Services project with same cubes as data sources

(on same computer), CPU was increased to 100% for more than 30 minutes

(process msmdsrv.exe) ... and I interpurt it.

Transfer projects to Windows 2003 SP1, but same result.
Do you have any idea what happens and how can I fix it ?

Best regards,

Siol En

OK, what happens.

I decreased attributes number (join some of them and my cubes become a little bit ugly), processing (for OLAP) a little bit increased (from 5-10 to 8-15 seconds).

Reporting Services proceed new cube for less than 2 minutes (bigger one) - waiting for congratulations

Now a big fight will be with a fact that Reporting Services didn't support "(All)" hierarchy member

Any help will be welcome, because my aggregation functions used exactly that property ... - "Percentage of Parent"; "Average", "Standart deviation"

Best regards,

Siol En

Reporting Services process Analysis Services cube with 100% load

Hi all,

I use SQL Server 2005 Developer Edition version 9.00.2153 on Windows XP SP2.

I build two cubes, process them and browse throw "Browse" tab in Analysis Services - time for loading was 5-10 seconds.

When I build Reporting Services project with same cubes as data sources

(on same computer), CPU was increased to 100% for more than 30 minutes

(process msmdsrv.exe) ... and I interpurt it.

Transfer projects to Windows 2003 SP1, but same result.
Do you have any idea what happens and how can I fix it ?

Best regards,

Siol En

OK, what happens.

I decreased attributes number (join some of them and my cubes become a little bit ugly), processing (for OLAP) a little bit increased (from 5-10 to 8-15 seconds).

Reporting Services proceed new cube for less than 2 minutes (bigger one) - waiting for congratulations

Now a big fight will be with a fact that Reporting Services didn't support "(All)" hierarchy member

Any help will be welcome, because my aggregation functions used exactly that property ... - "Percentage of Parent"; "Average", "Standart deviation"

Best regards,

Siol En

Friday, March 23, 2012

Reporting Services output format

I manually build my url for my reports. In the url I build, I can specify the output format I would like it to automatically use when the report opens. However, it always first opens the dialog box to either Save, Open, or Cancel. Is there anyway to bypass this and just open it in the format I have coded in the url? Thanks.No

Every download requires the users to accept or reject it. It's a security thing...

Imagine the chaos, if any developer could create a link, that when clicked, downloaded a file to your local drive and then executed that file.|||Makes good sense. Thanks for the input mbanavige!!!sql

Saturday, February 25, 2012

Reporting Services Deployment Problem

I'm new to Reporting Services and whenever I try to deploy a report I've
build in .NET, I have to turn off anonymous access to the ReportServer folder
in IIS. I imagine that Reporting Services wasnt installed correctly or that
there is some way to fix this. However, I havent been able to find any help
by searching the web or other sites I usually find helpful. Does anyone know
how to fix this?I suspect I am also in the same set of issues. My configuration is SQL
Server 2005, IIS5.1 on XP-SP2 using VS.NET 2005. The tool I am using to
debug IIS is the IIS 6.0 RK. I think my problems are related to it appears
that RS wants to be on a real server with SSL and Kerberos. NT
authentication doesn't appear to be enough to get to the virtual drive?
Al
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> there is some way to fix this. However, I havent been able to find any
> help
> by searching the web or other sites I usually find helpful. Does anyone
> know
> how to fix this?|||You lose functionality if you have anonymous access because everyone is
treated the same. RS uses roll based security. What I do is setup local
groups. To the local groups I add the appropriate domain groups/users. The
local group is assigned to a roll with certain rights, usually just browse
rights.
Here is a good link to read up on security.
http://odetocode.com/Articles/215.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
that
> there is some way to fix this. However, I havent been able to find any
help
> by searching the web or other sites I usually find helpful. Does anyone
know
> how to fix this?|||Bruce,
That may be helpful, but it looks cumbersome. I'm deploying reports across
a company Intranet. Would using role based security require me to give every
single user (there are a LARGE number) an account? What I would really like
is a way to have an 'anonymous' user group that can only browse the reports -
that way I dont spend half of my time fielding requests for access to the
reports and setting up new accounts. Any suggestions?
Derek
"Bruce L-C [MVP]" wrote:
> You lose functionality if you have anonymous access because everyone is
> treated the same. RS uses roll based security. What I do is setup local
> groups. To the local groups I add the appropriate domain groups/users. The
> local group is assigned to a roll with certain rights, usually just browse
> rights.
> Here is a good link to read up on security.
> http://odetocode.com/Articles/215.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > I'm new to Reporting Services and whenever I try to deploy a report I've
> > build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> > in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> > there is some way to fix this. However, I havent been able to find any
> help
> > by searching the web or other sites I usually find helpful. Does anyone
> know
> > how to fix this?
>
>|||Most domains have a generic group that everyone in the domain belongs to.
For instance yourdomain\users, at my company it is ourdomain\domain users.
So you should be able to just add that group once.
If you have resource kit installed there is a dos command called showgrps
that will show you all the groups you are part of, this would show you the
catchall group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> Bruce,
> That may be helpful, but it looks cumbersome. I'm deploying reports
across
> a company Intranet. Would using role based security require me to give
every
> single user (there are a LARGE number) an account? What I would really
like
> is a way to have an 'anonymous' user group that can only browse the
reports -
> that way I dont spend half of my time fielding requests for access to the
> reports and setting up new accounts. Any suggestions?
> Derek
> "Bruce L-C [MVP]" wrote:
> > You lose functionality if you have anonymous access because everyone is
> > treated the same. RS uses roll based security. What I do is setup local
> > groups. To the local groups I add the appropriate domain groups/users.
The
> > local group is assigned to a roll with certain rights, usually just
browse
> > rights.
> >
> > Here is a good link to read up on security.
> >
> > http://odetocode.com/Articles/215.aspx
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > I'm new to Reporting Services and whenever I try to deploy a report
I've
> > > build in .NET, I have to turn off anonymous access to the ReportServer
> > folder
> > > in IIS. I imagine that Reporting Services wasnt installed correctly
or
> > that
> > > there is some way to fix this. However, I havent been able to find
any
> > help
> > > by searching the web or other sites I usually find helpful. Does
anyone
> > know
> > > how to fix this?
> >
> >
> >|||Bruce,
Thanks for your help. I'm a bit over my head in this discussion - since I'm
a developer with very little to no experience in network administration /
server administration but I will look into setting up role based security.
Thanks for your help.
Derek
"Bruce L-C [MVP]" wrote:
> Most domains have a generic group that everyone in the domain belongs to.
> For instance yourdomain\users, at my company it is ourdomain\domain users.
> So you should be able to just add that group once.
> If you have resource kit installed there is a dos command called showgrps
> that will show you all the groups you are part of, this would show you the
> catchall group.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > Bruce,
> >
> > That may be helpful, but it looks cumbersome. I'm deploying reports
> across
> > a company Intranet. Would using role based security require me to give
> every
> > single user (there are a LARGE number) an account? What I would really
> like
> > is a way to have an 'anonymous' user group that can only browse the
> reports -
> > that way I dont spend half of my time fielding requests for access to the
> > reports and setting up new accounts. Any suggestions?
> >
> > Derek
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You lose functionality if you have anonymous access because everyone is
> > > treated the same. RS uses roll based security. What I do is setup local
> > > groups. To the local groups I add the appropriate domain groups/users.
> The
> > > local group is assigned to a roll with certain rights, usually just
> browse
> > > rights.
> > >
> > > Here is a good link to read up on security.
> > >
> > > http://odetocode.com/Articles/215.aspx
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > I'm new to Reporting Services and whenever I try to deploy a report
> I've
> > > > build in .NET, I have to turn off anonymous access to the ReportServer
> > > folder
> > > > in IIS. I imagine that Reporting Services wasnt installed correctly
> or
> > > that
> > > > there is some way to fix this. However, I havent been able to find
> any
> > > help
> > > > by searching the web or other sites I usually find helpful. Does
> anyone
> > > know
> > > > how to fix this?
> > >
> > >
> > >
>
>|||That's OK. A network admin or server admin will be able to translate my
suggestion and the link I sent you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:036B5699-7C2E-4F8D-BBEE-4CD1084C1EAD@.microsoft.com...
> Bruce,
> Thanks for your help. I'm a bit over my head in this discussion - since
I'm
> a developer with very little to no experience in network administration /
> server administration but I will look into setting up role based security.
> Thanks for your help.
> Derek
> "Bruce L-C [MVP]" wrote:
> > Most domains have a generic group that everyone in the domain belongs
to.
> > For instance yourdomain\users, at my company it is ourdomain\domain
users.
> > So you should be able to just add that group once.
> >
> > If you have resource kit installed there is a dos command called
showgrps
> > that will show you all the groups you are part of, this would show you
the
> > catchall group.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> > news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > > Bruce,
> > >
> > > That may be helpful, but it looks cumbersome. I'm deploying reports
> > across
> > > a company Intranet. Would using role based security require me to
give
> > every
> > > single user (there are a LARGE number) an account? What I would
really
> > like
> > > is a way to have an 'anonymous' user group that can only browse the
> > reports -
> > > that way I dont spend half of my time fielding requests for access to
the
> > > reports and setting up new accounts. Any suggestions?
> > >
> > > Derek
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You lose functionality if you have anonymous access because everyone
is
> > > > treated the same. RS uses roll based security. What I do is setup
local
> > > > groups. To the local groups I add the appropriate domain
groups/users.
> > The
> > > > local group is assigned to a roll with certain rights, usually just
> > browse
> > > > rights.
> > > >
> > > > Here is a good link to read up on security.
> > > >
> > > > http://odetocode.com/Articles/215.aspx
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in
message
> > > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > > I'm new to Reporting Services and whenever I try to deploy a
report
> > I've
> > > > > build in .NET, I have to turn off anonymous access to the
ReportServer
> > > > folder
> > > > > in IIS. I imagine that Reporting Services wasnt installed
correctly
> > or
> > > > that
> > > > > there is some way to fix this. However, I havent been able to
find
> > any
> > > > help
> > > > > by searching the web or other sites I usually find helpful. Does
> > anyone
> > > > know
> > > > > how to fix this?
> > > >
> > > >
> > > >
> >
> >
> >