Need some advice..kinda urgent!

Ok...so I have installed sql 2005 with the whole nine yards along with it. I also have an installation of sql 2000 along with 2000 reporting services on a seperate server. Finally I also have about 100+ million rows I need to report on it and I need it to look as clean as possible. Regional/Category type of breakdown/drilldown Pivot charts, drop down filtering etc...maybe even some cool .net features..

Obvisouly a template for 2005 is the way to go...but whatever is going to get me up and running with a webbased reporting interface as soon as possible that will do what I need it to do is what I am looking for.

I am not to bad with getting solutions running in visual studio but plan to have my develoepr actually do the quieries...just looking for a point in teh right direction.

Thanks in advance!

Michael404

Do the nine yards include Analysis Services 2005, which may be useful in achieving acceptable and predictable query performance with 100+ million rows?

Also, what degree of interactivity is needed in the web-based reports - will the features of Reporting Services suffice, or do your users need full pivot capabilities such as swapping axes?

|||

Thanks for the repy... Yes full reporting capabilities...

What do you mean about reporting servcies with full pivot capabilities...

I need drop downs for filtering and drill through capabilities wouldnt be bad either...however, I dont believe I understand the specifics on swapping axes?

Can you elaborate?

Thank you!!!

Michael

|||

Also...can you explain to me more on OLAP? I understand and have built cubes in the past but never got into querying them....how does that work? I know it runs along side Reporting Services but I am just curious..100 million rows is only a start and need to know the BEST way to report on this amount of data.

Thank you!

Michael

|||

This analysis from OLAP Report describes the defining "FASMI" qualities and applications of OLAP technology - the site also has other info on OLAP:

http://www.olapreport.com/Applications.htm

>>

OLAP applications

OLAP technology can be used in a wide range of business applications

...

>>

|||For example, consider a pivot table, where the user can interactively drag dimensions and drop them on rows or columns, swap the dimensions on rows and columns, or "stack" additional dimensions on rows and columns. These features are usually associated with OLAP client tools.

need query...its urgent

hi friends,

I am facing one problem...
I am using ms-access .
I have parent table with fields (empid(primary key),password,flag).and child table with fields (empid(fk),empname,date,intime,outime,remarks).

If i enter empid and name of month,the output contains fields like:empid,empname,date,intime,outime,remarks.

My problem is if i enter empid and name of month,it has to get all records of employee(holding that empid) throughout the specified month..

Please send solution for this...its very urgent.......Hi..
Send me your query for getting records
by
ramesh

need inventory datasets ! URGENT

i want to make business portal intellegence with sql2000 as my final project but i don't have datasets. i need iventory datasets like northwind or foodmart or middlewest. somebody help me please!!How do you have SQL-2000 without NorthWind? That is rather tough to do.

-PatP

Need Help... Urgent!

I've installed SQL Server 2005 from MSDN, however, while I was trying to
install the SP1 from the same DVD, it said:
"Shared String ID 11217 Not Found" with the body of the message saying
"Shared String ID 11216 Not Found"...
What could I do? How do I solve this?
I went to Microsoft.com to download the SP1 directly from there.. But the
error continues...
Thanks...
Hi Sonia,
Why dont you apply SP2 directly?
Ekrem ?nsoy
"Sonia.Madureira" <Sonia.Madureira@.discussions.microsoft.com> wrote in
message news:067A08DC-D5B1-4734-B24D-3A23E951F562@.microsoft.com...
> I've installed SQL Server 2005 from MSDN, however, while I was trying to
> install the SP1 from the same DVD, it said:
> "Shared String ID 11217 Not Found" with the body of the message saying
> "Shared String ID 11216 Not Found"...
> What could I do? How do I solve this?
> I went to Microsoft.com to download the SP1 directly from there.. But the
> error continues...
> Thanks...
|||Hi Ekrem,
Thanks for answer.. I've tried right now to install SP2 but it didn't work
out either..
When it's extracting, occours an error saying:
"The following error occoured", same in body - OK
When I click in OK it shows:
"A recently applied update, , failed to install" and in the content of the
report it says:
"EventType: sqlsetup P1 : unknown P2 : 0x0 P3 : unknown ..." , the
unknown repeats until P10...
Can you Help me?
"Ekrem ?nsoy" wrote:
Hi Sonia,
Why dont you apply SP2 directly?
Ekrem ?nsoy
|||I'm not sure if your prior SP installation attempt broke some SQL Server
binaries or not but it look's like it did. As you do not have a chance to
uninstall only the SP installation (that corrupted one), there is not
emerging an idea in my mind but to uninstall the problematic SQL Server
instance and install a new SQL Server instance from scratch and applying SP2
then.
I don't know your environment and if it's an important SQL Server instance
and can not be offline for a while or something don't blame me for my
comments =)
I hope others has a better idea on this problem.
P.S.
You said that an error occurs when the package is being extracted but as it
complains about the corrupted SP installation in the error message, I think
it finishes extracting the package and the problem occurs when it's checking
the system before applying the SP.
Ekrem ?nsoy
"Sonia.Madureira" <SoniaMadureira@.discussions.microsoft.com> wrote in
message news:523C6A93-BF60-492A-A58F-DF9729087D2E@.microsoft.com...
> Hi Ekrem,
> Thanks for answer.. I've tried right now to install SP2 but it didn't work
> out either..
> When it's extracting, occours an error saying:
> "The following error occoured", same in body - OK
> When I click in OK it shows:
> "A recently applied update, , failed to install" and in the content of the
> report it says:
> "EventType: sqlsetup P1 : unknown P2 : 0x0 P3 : unknown ..." , the
> unknown repeats until P10...
> Can you Help me?
>
>
>
> "Ekrem ?nsoy" wrote:
> Hi Sonia,
> Why dont you apply SP2 directly?
> --
> Ekrem ?nsoy
>
|||Thanks Ekrem,
I'll uninstall SQL and try again.
I've started this week serving as aprenctice in a company of services,
software, harware... So, they want me to learn as logic that is... (by the
way, forgive me my mistakes, i'm portuguese)
We install PC's, servers, etc in clients.. So we use SQL server...
They told me to install SQL server in my PC to start learning and when
errors occour, they answer to looke online.. I am looking everywhere but with
no luck... =( LOL
Thanks for helping me Ekrom... I will try to uninstall now... And try
again... =)
"Ekrem ?nsoy" wrote:

> I'm not sure if your prior SP installation attempt broke some SQL Server
> binaries or not but it look's like it did. As you do not have a chance to
> uninstall only the SP installation (that corrupted one), there is not
> emerging an idea in my mind but to uninstall the problematic SQL Server
> instance and install a new SQL Server instance from scratch and applying SP2
> then.
> I don't know your environment and if it's an important SQL Server instance
> and can not be offline for a while or something don't blame me for my
> comments =)
> I hope others has a better idea on this problem.
> P.S.
> You said that an error occurs when the package is being extracted but as it
> complains about the corrupted SP installation in the error message, I think
> it finishes extracting the package and the problem occurs when it's checking
> the system before applying the SP.
> --
> Ekrem ?nsoy
|||Thanks Ekrem,
I'm allready installing SP2...
I have my problem solved...
=)
|||That's a good news =)
I suggest you to be careful about installing SQL Server and its Service
Packs... For example, close any running apps that can\may prevent SQL Server
Setup to install its components successfully. It was your computer this time
but it could be an important SQL Server server. So ensure that there is a
clean and pure running system before starting installing SQL Server and its
Service Pack or something.
To learn better you could buy some books about SQL Server and your best
online assistant will be Books Online. Take advantage of it.
Good luck.
Ekrem ?nsoy
"Sonia.Madureira" <SoniaMadureira@.discussions.microsoft.com> wrote in
message news:BDDAFBE5-0CE4-4831-8827-314F87C4E5F0@.microsoft.com...
> Thanks Ekrem,
> I'm allready installing SP2...
> I have my problem solved...
> =)

Need Help... Urgent!

I've installed SQL Server 2005 from MSDN, however, while I was trying to
install the SP1 from the same DVD, it said:
"Shared String ID 11217 Not Found" with the body of the message saying
"Shared String ID 11216 Not Found"...
What could I do? How do I solve this?
I went to Microsoft.com to download the SP1 directly from there.. But the
error continues...
Thanks...Hi Sonia,
Why dont you apply SP2 directly?
--
Ekrem Ã?nsoy
"Sonia.Madureira" <Sonia.Madureira@.discussions.microsoft.com> wrote in
message news:067A08DC-D5B1-4734-B24D-3A23E951F562@.microsoft.com...
> I've installed SQL Server 2005 from MSDN, however, while I was trying to
> install the SP1 from the same DVD, it said:
> "Shared String ID 11217 Not Found" with the body of the message saying
> "Shared String ID 11216 Not Found"...
> What could I do? How do I solve this?
> I went to Microsoft.com to download the SP1 directly from there.. But the
> error continues...
> Thanks...|||Hi Ekrem,
Thanks for answer.. I've tried right now to install SP2 but it didn't work
out either..
When it's extracting, occours an error saying:
"The following error occoured", same in body - OK
When I click in OK it shows:
"A recently applied update, , failed to install" and in the content of the
report it says:
"EventType: sqlsetup P1 : unknown P2 : 0x0 P3 : unknown ..." , the
unknown repeats until P10...
Can you Help me?
"Ekrem Ã?nsoy" wrote:
Hi Sonia,
Why dont you apply SP2 directly?
--
Ekrem Ã?nsoy|||I'm not sure if your prior SP installation attempt broke some SQL Server
binaries or not but it look's like it did. As you do not have a chance to
uninstall only the SP installation (that corrupted one), there is not
emerging an idea in my mind but to uninstall the problematic SQL Server
instance and install a new SQL Server instance from scratch and applying SP2
then.
I don't know your environment and if it's an important SQL Server instance
and can not be offline for a while or something don't blame me for my
comments =)
I hope others has a better idea on this problem.
P.S.
You said that an error occurs when the package is being extracted but as it
complains about the corrupted SP installation in the error message, I think
it finishes extracting the package and the problem occurs when it's checking
the system before applying the SP.
--
Ekrem Ã?nsoy
"Sonia.Madureira" <SoniaMadureira@.discussions.microsoft.com> wrote in
message news:523C6A93-BF60-492A-A58F-DF9729087D2E@.microsoft.com...
> Hi Ekrem,
> Thanks for answer.. I've tried right now to install SP2 but it didn't work
> out either..
> When it's extracting, occours an error saying:
> "The following error occoured", same in body - OK
> When I click in OK it shows:
> "A recently applied update, , failed to install" and in the content of the
> report it says:
> "EventType: sqlsetup P1 : unknown P2 : 0x0 P3 : unknown ..." , the
> unknown repeats until P10...
> Can you Help me?
>
>
>
> "Ekrem Ã?nsoy" wrote:
> Hi Sonia,
> Why dont you apply SP2 directly?
> --
> Ekrem Ã?nsoy
>|||Thanks Ekrem,
I'll uninstall SQL and try again.
I've started this week serving as aprenctice in a company of services,
software, harware... So, they want me to learn as logic that is... (by the
way, forgive me my mistakes, i'm portuguese)
We install PC's, servers, etc in clients.. So we use SQL server...
They told me to install SQL server in my PC to start learning and when
errors occour, they answer to looke online.. I am looking everywhere but with
no luck... =( LOL
Thanks for helping me Ekrom... I will try to uninstall now... And try
again... =)
"Ekrem Ã?nsoy" wrote:
> I'm not sure if your prior SP installation attempt broke some SQL Server
> binaries or not but it look's like it did. As you do not have a chance to
> uninstall only the SP installation (that corrupted one), there is not
> emerging an idea in my mind but to uninstall the problematic SQL Server
> instance and install a new SQL Server instance from scratch and applying SP2
> then.
> I don't know your environment and if it's an important SQL Server instance
> and can not be offline for a while or something don't blame me for my
> comments =)
> I hope others has a better idea on this problem.
> P.S.
> You said that an error occurs when the package is being extracted but as it
> complains about the corrupted SP installation in the error message, I think
> it finishes extracting the package and the problem occurs when it's checking
> the system before applying the SP.
> --
> Ekrem Ã?nsoy|||Thanks Ekrem,
I'm allready installing SP2...
I have my problem solved...
=)|||That's a good news =)
I suggest you to be careful about installing SQL Server and its Service
Packs... For example, close any running apps that can\may prevent SQL Server
Setup to install its components successfully. It was your computer this time
but it could be an important SQL Server server. So ensure that there is a
clean and pure running system before starting installing SQL Server and its
Service Pack or something.
To learn better you could buy some books about SQL Server and your best
online assistant will be Books Online. Take advantage of it.
Good luck.
--
Ekrem Ã?nsoy
"Sonia.Madureira" <SoniaMadureira@.discussions.microsoft.com> wrote in
message news:BDDAFBE5-0CE4-4831-8827-314F87C4E5F0@.microsoft.com...
> Thanks Ekrem,
> I'm allready installing SP2...
> I have my problem solved...
> =)|||Thanks so much for helping me...
I have a lot to learn... =)
i will look for ebooks about it...
Thanks again!

Need Help! [Urgent]

would it be possible to have a uniform color for pie slices in SQL Reporting Services??
i mean if im going to made 3 charts with the same categories, it should have uniform color...

For example:
Chart1
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart2
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart3
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

So then, how can i pick color for pie slices in Excel and SQL Reporting Services?? I really need your help ASAP!!! Thanks

Hello,
According to the tests I've made, I've discovered that if the resultare sorted in the same order on the different charts, the slices are inthe same color : So, my answer would be : ORDER BY ;)