Olap Reporting With .net2005
May 30, 2006Which forum do i go to to ask questiosn about configuring olap reports with .net 2005
View 1 Replies
ADVERTISEMENT
Is Reporting Servcies For OLAP??
Jan 6, 2005Hi,
Based on the few articles/posts that I have come across it appears to me that reporting services is probably an awesome tool for relational output in tabular format but is not for cube analysis.
Is this assumption correct?
I'll appreciate some feedback. Thanks.
Sql2005 Conflict With Vs.net2005
Jun 2, 2007when i install vs.net2005 , so .net framwork 2 installs with it ,then when i m trying to install sql2005 it give me to uninstall .net framwork, and by default .net framwork 2 beta comes with it which is not compatible for vs.net 2005 , shortly when i run vs.net2005 ,sql2005 is not working and viseversa
View 1 Replies View RelatedQ: Regarding Sql Server 2005 With Vs.net2005 Included
Aug 8, 2007hi,
i'm not sure where to post this.. but nway...
I'm new to vs.net 2005, before we switch to sql server 2005, i've been using vs.net 2003, and sql server 2000, and 3rd party sql reporting services 2000. so i use vs.net for front end, sql as back end, 3rd party as reports printed out of front end.
but now.. i have an installer of sql server 2005, and when i install it, it includes a vs.net 2005 w/c i can use also to create my reports.. but about the vb.net? does it have anything installed with it? is there a seperate installer for vb.net that i need to purchase? or maybe download from?
i created some reports from business intelligence and i have the report.. but i need to make its user interface using vb.net.. and i can't find it
OLAP Services: Automating Archival/Restore Of OLAP Databases
Sep 19, 2000Hello All,
Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.
--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220
Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com
"Once in a while you can get shown the light
in the strangest of places if you look at it right"
JG 1942-1995 RIP
How To Manage Sql Server Transaction In Desktop Networking Application Vb.net2005?
Jun 10, 2006hi
i want to know that how to manage the sql server transaction in a
big desktop networking application?
for example
there are 200 tables in
database. many of that tables have relatationship. i have a form in
frontend which holds nere ablut 50 tables deffrent calculated amount. i
want to ADD, EDIT and DELETE, SAVE(commit), CANCEL(roll back) them and
same time another use will do the same work from another pc. if there
are 100 user does the same work (add, edit, delete, save, cancel) how
could i magage my sql server data???
i also want to know that
1 kind of
proffessionsl way to use sql server and vb.net?
2 what kind of septs to
develop a desktop networking application with sql server?
3 how i could
manage the transaction in sql server when there are many-many user
working in the same database(add, edit, delete, save-commit,
cancel-rollback).<img src="images/emoticons/smile_baringteeth.gif">
How To Repair A Corrupted OLAP Database? (was Olap!:)
Jun 12, 2007How to repair a corrupted OLAP database?
View 2 Replies View RelatedParameter Passing In SQL Server 2005 Integration Services (SSIS) 2005 From VB.Net2005
Sep 7, 2007Is it possible to parm in a value to a SSIS
in my SSIS i have a variable;
Name : FileName
Scope : PackageName
Type : String
Value : ""
I have tried adding the following code in my vb.net project ;
pkg.Variables("filename").Value = "C: emp estfile.001"
pkg.execute()
but come up with the following error
A first chance exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll
Public member 'Variables' on type 'IDTSPackage90' not found.
can anyone help ?
OLAP And ASP.NEt
Aug 2, 2005Hi,
I am looking at deploying an ASP.NET site which accesses an OLAP database - Microsoft Analysis Services
My question is how is this normally done:
Straight SQL / Stored Procedures
3rd party Adhoc plugin
Anything else
If there is anyone out there with experience in using ASP.NET and
Analysis Services I would be interested in hearing how they did it -
Database Architecture
System Architecture
and any
pitfalls etc...
Thanks in Advance
Jerry
OLAP
Aug 12, 2005Does any one know a very good control for OLAP in ASP.NET?
View 2 Replies View RelatedOLAp And MDX
Jul 28, 2000How do I use vba string functions in MDX queries? The on-line help says that the functions can be used but I can't figure out the right syntax for it. PLEASE HELP!
I want to take the first letter from a level i.e.([NET INCOME] in the e.g. below) and display it.
For eg.
WITH MEMBER [DIMENSION].[NET INCOME].A AS 'LEFT({[DIMENSION].[NET INCOME].MEMBERS,1})'
SELECT
measures ON COLUMNS,
[DIMENSION].MEMBERS ON ROWS
FROM CUBE a.
OLAP
Jan 17, 2001I have install OLAP srvice on SQL Server 7.0 server.
When I try to connect to OLAP server I get the following error:
'cannot connect to the registry on the server computer'
Does anyone know how to fix this problem.
Thank You,
Mark
SQL 70 And OLAP 2K On Same Box
Sep 25, 2001Has anyone tried installing an OLAP Manager 2000 instance on a server that already supports SQL 7.0 and OLAP 7.0? We will not be using the OLAP 7.0 instance so we would like to either upgrage OLAP 7.0 to OLAP 2000 or unistall OLAP 7.0 altogether. Any feedback would be helpful. Thanks. James.
View 2 Replies View RelatedOlap
Jul 7, 2004hi,
i need "microsoft(r) sql server(tm) 2000 analysis services step by step" in digital,can you help me ?
shawnlee@cena.com.cn
OLAP Help
Jan 20, 2004i do not know if i am posting in the right place so forgive me if i have.
also i have search and cannot find any answers to this.
ok, i have Windows server 2003 and i want to run SQL on it, i got SP3a and i found out i need something like OLAP, and my PC does not have OLAP on it.
so i was wondering if someone will tell me how/where i can get if from.
thanks alot.
Mrbob2
OLAP
Mar 20, 2007Mary writes "Hi
Could you give me some notes about ALAP ? What is ALAP exactly? What is the usage of this part of SQL? Could you give me some example.
Thanx"
I Can't See OLAP Databases ?
Jul 6, 2001I was working with an OLAP Services Processing Task when I ran
into some difficulties. I was prompted with a message which told
me that the object could not be found.
When I went back to the OLAP Manager I was not able to see the
databases for that server.
Does anyone know why I can no longer see these databases i have
tried refreshing/rebooting......??
Thanks,
Ruaidhri.
OLAP Security
Oct 2, 2000Analysis services is installed on a Windows 2000 server (call it computer A) in Domain A. SQL 2000 has been installed on the server using mixed security. All of the SQL services are running under an account in Domain A (not local system).
The problem is the computer (call it computer B) I wish to run Analysis Manager on and use to administer the Analysis services on Computer A is in Domain B. There are no trusts between Domain A and Domain B.
Can Analysis services be administered by a computer in a domain not trusting the domain that the server running Analysis server is in?
Any help would be appreciated.
Thanks
OLAP - Very Urgent
Dec 6, 1999Hi,
Can anyone tell me where to fine some good help on designing Date type dimensions in an OLAP cube.
This particular thing has been a pain for me..
I have a Time dimension in my CUBE which has year-week-day as levels.
I want the week to start from Monday and span seven days ( naturally !! ). But OLAP surprises and entertains me by showing different number of days in every week. Whatever I do, it never starts a week on Monday and spans it for next 7 days consistently.
Help.
OLAP Manager
Mar 29, 1999I've installed SQL7.0 and OLAP service on my PC(windows 95), but I cannot find the OLAP Manager. Can an OLAP Manager be installed on Windows 95? If it cannot, can I create an OLAP database (or application) on my PC?
View 1 Replies View RelatedOLAP Server
Apr 15, 1999Anyone managed to get the OLAP server installed onto SQL7 Desktop?
I'm running it on Win98 and the installation only offers the Client and sample applications.
Obviously the client won't connect as there's no server to connect to.
The documentation on what does/doesn't run in Desktop version doesn't mention OLAP server.
Please email reply to me at RussLewis@msn.com
Thanks
OLAP Services
Mar 2, 1999I have installed OLAP services along with SQL Server 7.0. I want to use the sample MDX application supplied with the CD. When I try to use the dsample application, it comes up with a dialog to enter the server name and gives me an error unable to connect to the OLAP server.
My computer is Windows 98. Do I need to install OLAP Server ? If so how ?
Thank you
OLAP License?
Mar 8, 2001I can't find anything written about licensing for OLAP anywhere. Do I presume correctly that it doesn't require one of its own?
Thanks for any info.
Simon
OLAP And Excel
Jun 6, 2001I keep getting this error when trying to connect users to the OLAP server from
Excel.
"Unable to open connection.
Cannot Connect to server 'OLAP Server Name'.
OLAP server error: The operation failed due to network problems."
When I use this excel locally on my machine it works just fine. Any ideas?
OLAP Tools?
Oct 4, 2004So I am starting to look at an OLAP problem having been an OLTP DB wonk for several years.
All very nice. Am bending my head aorund cubes and the dimensions trciks and learing to choose them more carefully.
Have wokred through the various chapters of various SQL books (OLTP books with a couple of chapters of OLAP I admit) and am starting to feel if not comfortable with it at leats not compleetly terrified.
Now the Analysis manager in SQL is all well and good but I'm not about to hand it to the accounting monkeys that work here.
Does anyone have any suggetsions of some good OLAP specific books and any Cube viewing tools/suites/utilities that I can give to the computer-illiterate bean counters I work for?
many thanks
Steve
OLAP Security
Jul 17, 2006Hello DBForums
View 1 Replies View RelatedOLAP Testing
Jan 15, 2007Hi Guyz ,
I'm new to this forum and as well as new to OLAP testing . I would like to know OLAP testing and guidance for SQL server anlaysis services .
I have been trying install SQL server 2000 in my system but it not going through, Can anybody send information how to install SQL server and how to play with sample database.
OLAP Problem!
May 31, 2007I'm trying to retrieve calculated members from a cube using the OPENQUERY function and a OLAP linked server, the results from MDX Queries are then stored to a SQL Server DB Table.
below is the error message I get:
Could not get the data of the row from the OLE DB provider 'MSOLAP'.
OLE DB error trace [OLE/DB Provider 'MSOLAP' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=[Measures].[first column] STATUS=DBSTATUS_E_UNAVAILABLE], [COLUMN_NAME=[Measures].[second column] STATUS=DBSTATUS_E_UNAVAILABLE]]
When I run the same query in MDX Sample Application it works fine!
Any help Please!
Oltp && Olap
Dec 19, 2007hello everyone,
Is it make sense to create 2 databases, OLTP for the insert, update and delete and OLAP for selection
and i'll sync between the 2 databases.
Thanks
HELP OLAP Cubes
Mar 3, 2004When I try to modify a OLAp Cube, suddenly appears a Error message
"Unknow Error. Restart the Application"
And this break my cube down
This is not always, just some time, for example when I proof the cube on Microsoft Excel or After I backed up the databes of analysis
What can I do?
I'll thanks your quick answer
NOTE: My cube use MOLAP aggregations
OLAP Details Please
Aug 28, 2007Can somebody please go in depth detail what exactly is done in OLAP? i know it deals with the data warehouse end. but what does the SQL DBA do in the OLAP end? please elaborate. thanks.
View 5 Replies View RelatedOLAP Performance
Mar 28, 2006Just to verify that I'm not insane:
Does Reporting Services have SERIOUS problems performance wise with OLAP data? Reports running directly against our relational datawarehouse run FASTER than reports going against the OLAP cubes. How can this be?
<rant>
At first i thought i was just missing something but the "upgrades" to reporting service have been a HUGE dissapointment, at least in the OLAP field:
- They STILL flatten the result set. How can this be after FIVE years??? After all the hype about UDM and improved integration with analysis services they STILL do this???
- Report builder: Has anyone seen a worse implementation of a reporting tool? Report models?? What about the UDM thats supposed to bridge the gap between analysis and reporting? Integration with SSAS? What integration? If anyone is using this for anything serious (and im not talking tech demos) i would like to know.
Is this what Microsoft defines as "Enterprise Reporting"?
</rant>
.. phew.. needed to get that off my chest.
Olap Server
Mar 16, 2006Hi everyone, Sql express support olap server?, because I try it to make an a Pivot table in Ms Excel, but i can't, then Sql server have this feature?thx.p.d: sorry but my english :P
View 3 Replies View Related