I am trying to find some development best practises for SQL Server Reporting Services, Analysis Services and Integration Services. Does anyone have some useful links or guidance they can offer on this subject? ...
What is the best way to deploy an analysis services project database to a different domain. I have network access to that domain (I am able to ping it). When I try to deploy the SSAS project to a live server in a different domain I get the following error: Error 8 The project could not be deployed to the 'SERVER' server because ...
The ERP system that I use is "stuck" in SQL 2000. The vendor states that it will not work, even in 2000 compatibility mode with any version of SQL higher than 2005. Due to corporate red tape I cannot use SQL 2005. Can I install 2008 on the same server as a separate instance and then use the tools of 2008 to create SSRS and SSAS proje...
While installing SQL Server 2008 (which included SSAS), I set these permissions, giving a domain group that held our SQL Service Account: . Now I need to change that group to a different one that includes a second service account, but I'm not able to conclusively find the permissions it set. There was overlap with our last domain group,...
I'm looking to automate the deployment of XMLA scripts. I've come across an article that gives a small demo, but I'm hoping to find more info. Specifically, where is the documentation for Microsoft.AnalysisServices.Xmla.XmlaClient and what is the best approach for overridding the database and connection values that are embedded in the X...
Hi, I'm trying to achieve the following: I have a measure: [Measures].[Sales] and a time dimmension: [Time].[Year - Month - Day]. I would like to add new measure: [Measures].[Sales SPLY] to work in the following way: MONTH-----------------Sales--------------Sales SPLY 2009 January--------120 000,00--------110 000,00 2009 February ---...
If I have a dimension in Analysis Services where the base table has columns like this: TransTypeKey TransTypeCode TransTypeDescription TransCategoryCode TransCategory Description where the description columns are just friendly names for the corresponding 'code,' what's the best way to capture that? Concatenate the code and description...
Some dimension tables in my warehouse: DML Site Id bigint Name nvarchar(256) Primary key (Id) DATA SiteId Name 2 Site 2 3 Site A DML UserSite Username nvarchar(256) SiteId bigint Primary key (Username, SiteId) Foreign key (SiteId) referrences Site(Id) DATA Username Sit...
Here is the steps to my problem: I have a MOLAP cube with MOLAP dimensions on the AS2008 server I connect to it with Excel 2007 and save it in a local cube file (.cub) I disconnect from network, then I try to open the offline cub file through excel. It is successful. I copy the .cub file to another machine, start Excel, try to connect ...
Mulling over something I've been reading up on. According to Chris Webb, A linked measure group can only be used with dimensions from the same database as the source measure group. So I took this to mean as long as two cubes share a database, a linked measure group can be used with a dimension. So I created a new cube and ad...
I'm wondering if there are any performance implications from adding a lot of calculated members to my cube. On one hand, it's nice to have things defined once, located centrally, tested, and available for use from any client which doesn't support MDX. On the other hand, some of these members I'm adding might not be used very frequently...
I'm rather new to SSAS and am completely stumped on how to solve this problem. I have a dimension called Thresholds. Within the Thresholds dimension there are the following Members: [Threshold Year], [Threshold1 Amount], [Threshold2 Amount], [Threshold3 Amount] I also have a measures called [Qualifying Commission], [Tier1 Amount],...
Hi, I was trying to run the cube script to install the cube-database in the analysis server. I changed the data source to point to the server I wanted, but I got the error as in the title with the error codes Error Code = 0x8007000E, External Code = 0x00000000: I tried the properties of the analysis server too and set the "MemoryLimit...
Hi, While processing an SSAS cube, the query that I got from processing window like "under SQL queries 1" is producing resultset, but when the processing is done and the measures are pulled into the brower, the values do not show up. What could be the reason??? ...
I have an analysis services database with an excel front end. At one point I had the KPI coming though to excel 2007 but now I have no option to select them. Is this a known issue? ...
Starting with the customary - "please excuse me as this is my first post and i'm a relative beginner" disclaimer, i have the following question... I work for a not for profit campaigning organisation, I've set up an SSAS solution to measure campaigning actions (e.g emailing the priminister) taken by a set on campaigners (customers) the ...
Background) I've gone through the process of building a fact table for our inventory data that will in theory act as a nightly snapshot of our warehouse. What is recorded is information such as quantity, weights, locations, statuses, etc. The data is very granular and in many cases not specifically related to a single entity (our source ...
For anyone working with SSAS 2008, a question: I have a rather large dimension whose key attribute is a combination of two integer fields. I have the key attribute's Key Columns set up as a collection consisting of the two integer fields, and for the name column I have a WChar field which concatenates the two integer fields like so ("F...
Starting with the MDX below I'd like to add two ranking columns that evaluate the member "Close Ratio". The first rank would be based on the sales rep population. Let's say there are 100 reps then if no close ratios repeat the rep with the highest ratio would be number 1 and the rep with the lowest ratio would be number 100. The second...
Can there be multiple search conditions in the "filter funtion" in mdx. If possible how do I put [Measures].[x] > 0 and [Measures].[y] = 0 in filter(set expression, search condition) thanx ...