Don't mean to intrude the forum, but i'm despereate...
I have a client in New York City who is looking for a MS Analysis Services Consultant. Please review the spec below and contact me if you are interested in discussing any further. Thanks, Michael
MS Analysis Services Consultant
Minimum of 5-7 years of overall IT experience
Hands-on, enterprise-wide, data warehouse experience.
Strong background in multi-dimensional databases
Must have a minimum of 2 years of experience creating applications and reports using MS Analysis Services, as well as cube creation, optimization and trouble shooting.
Prior experience with MS Analysis Services administration and managing cubes is also a plus.
Responsible for designing OLAP applications with MS Analysis Service (OLAP Server) and creating Cubes, Dimensions, Calculated measures with MDX, designing ETL custom scripts
Must have very good communication skills
I have some questions about SQL Servers 2000 and 2005 compatibility. In my configuration I have to use both servers. The cubes are stocked in 2005 server. May I transfer from 2005 to 2000 Analysis Services the cubes?
If yes, what is the procedure? The result of migration is the same in the two different versions?
I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions. When configuring the Power BI analysis services connector, at the point where you enter Friendly Name, Description and Friendly error message, when you click next I receive the error "The remote server returned an error (403)." I've tested connecting to the database from Excel on a desktop and connect fine.I don't use a "onmicrosoft" account so don't have that problem to deal with.
We use Power BI Pro with our Office 365. As far as I can tell that part is working ok as I pass that stage of the configuration with a message saying connected to Power BI.The connector is installed on the same server as tabular services, its a Win2012 Standard server. The tabular instance is running a domain account that is the admin account for the instance (this is a dev environment) that account is what I've used in the connector configuration. It's also a local admin account. There is no gateway installed on the server.
I have a cube that we are processing nightly via an Analysis Service Processing Task in SSIS. In order to increase the performance of the processing time, we elected to use a lot of rigid dimension attributes, and do a full process of everything in the SSIS task. The issue that I am having is that after that task completes, I need to go into Visual Studio to deploy the cube becuase we are unable to browse or use the cube. This issue seemed to start once we changed the SSIS Analysis Service Processing Task to do a full process on the dimensions, rather than an incremental.
I would expect that once development is done, and it is processed and deployed, that is it. My thinking is that the SSIS task should just update the already deployed cube,
How to right choose key column in"Mining Structure" for Microsoft Analysis Services?
I have table:
"Incoming goods"
Create table Income ( ID int not null identity(1, 1) [Date] datetime not null, GoodID int not null, PriceDeliver decimal(18, 2) not null, PriceSalse decimal(18, 2) not null, CONSTRAINT PK_ Income PRIMARY KEY CLUSTERED (ID), CONSTRAINT FK_IncomeGood foreign key (GoodID) references dbo.Goods ( ID ) )
I'm trying to build a relationship(regression) between “Price Sale” from Good and “Price Deliver”.But I do not know what column better choose as “key column”: ID or GoodID ?
I have a Small company in Delafield WI. And am moving to MS SQL. I know just enough to get me in trouble (I`m a VB guy) but can`t afford the self inflicted pain. Willing to work over the net, phone and/or let you RAS in. Or if you are in the area `Come on down`
Don't know if this is the appropriate forum. I am looking for an experienced SS consultant to review our setup, hardware architecture, recovery plan, and to provide high-level advice moving forward. My company is a CRM hosted software provider with a dynamic, metadata-based product built in Visual Studio 2005. Currently we run on SS 2000, but plan to migrate to SS 2005 or 2008. We anticipate quite a bit of growth and want to make sure that we are on the right path. Let me know if you are interested or know someone who is.
Looking for a consultant with solid experience in application anddatabase security for a project in the GTA.CONTACT---------------------------------------------------Please send your resume to:Join Bytes!
Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:
"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"
The cube name is not specific, it will fail and any of my cubes could be in the error log
If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.
I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.
When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.
I've done the following with no effect.
" Have run via AS and works fine " No specific cube it fails on " Have created a Dimension only package, same problem " Changed the maxmemorylimit " Changed the connections to localhost " Memory DOES NOT max out on server
Server Specs: Windows Server 2003 Standard + Service Pack 2 4GM ram, 2GB paging file
I think I've seen a similar post on a blog or on the forums - but it seems like this should be possible -
I have an MDX query - that works fine in SQL Enterprise Manager, and has my dimension members on columns, and my measures on the rows. When I try the same query in Reporting Services, I get the error:
"The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension.. Parameter name: mdx (MDXQueryGenerator)"
Although it works when you pivot the view, I really need my data presented with the members on the columns and the measures on the rows. Another forum post mentioned using the SQL 9.0 driver, but I can't see this listed anywhere (the only one I see is the .NET framework Data Provider for Microsoft Analysis Services).
Here's what my query looks like -
SELECT { [Time].[Month].&[2006-09-01T00:00:00] , [Time].[Month].&[2006-10-01T00:00:00], [Time].[Month].&[2006-11-01T00:00:00], [Time].[Month].&[2006-12-01T00:00:00] } on COLUMNS, { [Measures].[Unique Users], [Measures].[UU Pct 1], [Measures].[UU Pct 2], } ON ROWS FROM [Cube]
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
Hi,I wonder if anyone can help with the following on a fee paying basisfor the the design or development of some type of script or utility orpiece of code to do the following work.I wish to retrieve some data from an online database that is in thepublic domain. The online database has a search facility that matchesthe entry (name) in a search box then returns a screen stating that amatch has been found or not found.If a match is found there is a button to click that proceeds to thescreen containing the data which is simply two names. It is these twonames that I wish to retrieve and store them in something like a textfile where they are associated with the original entry (name) used inthe search box.I have a list of the entries for the search box that can be suppliedin sample format for testing as a columnar text file or commadelimited file or a spreadsheet.. I would need the procedure toprocess the list of search entries, retrieve the data then move on tothe next one in the list. Obviously, if a match was not found then theprocess would need to move on the the next entry in the list withperhaps a message saying "No Match" until the entire list wasprocessed.The PC I hope to run the process on is a Windows XP machine and if Ineed to purchase any particular software that is necessary for the jobthen I am quite willing to do so. Also, as I pointed out above I wouldpay for the work to be done.I hope that I have explained the above OK and that I have posted it tothe correct newsgroup(s). If it is not in the correct newsgroup Iwould be grateful if anyone could point me in the right direction.RegardsDave Gibson
Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services.
Problem: Reporting Server does not apply Analysis Services Role after login.
Details:
I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role.
On the Reporting Server I set the data source to :
* Credentials supplied by the user running the report and Use as Windows credentials when connecting to the data source
Internally when I connect devsql2005/Reports/ReportName I get the user and password fields. When I fill them in I get the report but I can see all the data while my role was restricted to see only few results.
Can anyone suggest what may be wrong? Any articles or tutorials on how to setup and deploy solutions where Report Server is talking to Analysis Services and NOT Sql Server.
I have Reporting Services on one server and SQL and Analysis Services on another Server. I can develop a report using Analysis Services as the source from my local machine and it works fine. When I deploy it to the Reporting Services Server, it gives the following error:
An error has occurred during report processing. Cannot create a connection to data source 'DataSource1'. A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it
Hello I have been working on reporting services fetching data out of Sql Server. I want to know,if there are any sites than have information on working with MS.Services and Analysis Services together. Analysis Services is something I have no knowledge about.
I have an important question and I've been roaming on MSDN and the internet to find a CLEAR answer. I'm really stuck here.
Is there a way to build a DYNAMIC Report with Visual Studio 2005 (SQL Server Business Intelligence Development Studio) and having a Cube (SQL Server 2005) as datasource?
I want a report that will act as the interface of the Cube browser in Analysis Services. I don't want to give access to the Cube Browser to users, but I want them to be able to drill-through the cube.
Hi, Im pretty much new to AS and would like to ask some silly questions why I cant browse the data in my cube.
Version - SQL2K Developers Edition on W2K OS
Problem: Im doing the tutorial which comes with Analysis Services. I have successfully followed their instructions and created and processed the 'Sales' cube.
However when i browse the cube, i get the error Unable to browse the cube 'Sales'. Unspecified error
will anyone help me as iam new to AS and i created the cube using the sample tutorial.but when i try to browse the cube it is showing an error as "unable to browse the cube,unspecified error'.pls help me thanx in adv
hello everybody I am new to bi project.my client want user activities to be captured into chart and cube.Into this context i just started reading analysis services.i read some document and implemented one simple analysis service project using adventureworksdw database. My question is this like i have to work on analysis services using my own db.so directly can i use clint db(ie user table) or i need to write some script to change this db into a db which can produce cube and dimention.
I installed MS Analysis Services in my Windows XP (with SP1) desktop. When I try to expand the "+" sign beside the server, I got the following error message: "Unable to connect to the registry on the server, or you are not a member of the OLAP Administrators group on this server."
It is very weird that occasionally I can connect to the server without the above problem. But most of time, I cannot connect to the server and will get the above the error message.
A lot of job postings these days for SQL DBA's list the requirement of Analysis Services. Not having any experience with it I'm wondering what exactly is meant? Of course its going to vary from company to company, but I really have no clue what they mean in general? Is it cube design? MDX query writing? Simply backing up? To be clear, Im asking in regards specificically for a DBA, not a Developer.
I have been looking at Microsoft Business Intelligence tools. SQL Server 2005. I see great potential with Analysis server, and creating data cubes for reporting. This will offload much processing from my transactional servers.
I just haven't been able to identify the process for automatically updating my cubes over night. The documentation leaves me baffled.
Hi. I have a problem with the caculation of the dimensions in the Analysis Services and I need help. In a certain dimension I make some calculations with the "personalized member formulas". Some cells are modified after this calculations. After this, in another dimension, other calculations are made using again the "personalized member formulas". With this operations some cells that were modified in the previous dimension should be modified again, but they aren't. Is there a way to fix the sequence of the calculation of the dimensions? Do they get calculated at the same time or some get done before others? Once one of this cells are modified using those formulas is it possible to modify them again? In the Hyperion's Essbase software ther is an option to calculate some dimensions before others. Does Analysis Services has that option or something similar?. I hope you can help me. Thank you very much.
I am looking for some high level resource for comparing SQL server 2005 Analysis Services to SAS. Some thing of a white paper or independent study nature will be grateful.
I hope some experts here have the expereices working with both and can speak of their expereices.
Does anyone know if the analysis services CD is seperate from the SQL 2k5 enterprise CD's? We are trying to install it on a server and when we go to add / remove programs to check if analysis services is installed it is not listed. To add it it tries to go to the setup process but asks for the analysis services cd..which I cannot find anywhere! Is this a seperate CD install ?
Suppose I have a dimensional data warehouse in a relational SQL Server2K5 database. What's the primary benefit of moving to SSAS? What does it buy me? My understanding is that when creating a SSAS cube, analysis services will slice and dice the data on all dimensions that fact is tied to, and calculate all the possible aggregates and intersections. Is that true? If so, is SSAS really only useful to support heavy ad-hoc reporting needs?
I was at a Microsoft sales presentation last week for the new versionof SQL Server, Yukon. They had an extensive presentation on SQLServer and Reporting Services but didn't mention Analysis Services.When I asked about the future of the product the MS Sales rep couldn'tgive me any info. When I looked at the big product chart I got at thepresntation, Analysis Services wasn't on it. There was just boxrefering to Reporting Services and XML. Does anyone know what or ifthere is a future for Analysis Services?
