Hi, I need to allow my end users to view SQL Server Analysis Services data mining model (to be exact Association finding). I'm looking for a tool which can do the job. For the cubes I'm using Excel OWC, and I'm quite satisfied. So far I had found only DM Companion . But I'm struggling to find anything else. Can you recommend somethi...
I have a cube built in SSAS2008 that is built upon 2 tables - Accounts and Payments. Both tables have dimensions and measures, and it appears to be working relatively well - I can get payments for accounts broken down into dimensions for either payments or accounts, and account measures broken down into account dimensions. What I can't...
I must first admit that I'm new to Analysis Services but now must extend an existing complex cube with a new dimension. So its even difficult to tell where my problem is without saying that i dont even have a plan how to start. Ok, i will try to tell what i want to achieve. Given is a Datasourceview with a named calculation 'Returns'. I...
I'm still learning the ropes of OLAP, cubes, and SSAS, but I'm hitting a performance barrier and I'm not sure I understand what is happening. So I have a simple cube, which defines two simple dimensions (type and area), a third Time dimension hierarchy (goes Year->Quarter->Month->Day->Hour->10-Minute), and one measure (sum on a field c...
Hi, Using : Analysis Services 2008, Excel 2007 I've created a Cube and am able to connect from Excel. Cube does have some Calculated Measures, Named Sets and KPIs. Now, I'm been writing some MDX in MS SQL Server Management Studio. How do I write MDX queries and make them available through the Cube? Can I create Cube Views / Cube spr...
I'm new to ssas and i'm fighting with users permissions... I have a cube with a region dimension i.e region A and region B. I created a role to filter dimension data so that members of that role have only access to region A. I put user A in this role. Now, when I test this configuration, if I select the role A in the security context,...
I have database where i have all sales data. And I need to calculate average sales qty for previous 3 months for current year Let's consider that we are browsing the cube1: select AdjSalesQty1, SalesQty on rows & Calendar months on columns condition is get the average for current year and where dimension for previous 3 months is set...
I'm trying to set up a cube calculation. My current remit is that I will receive exchange rates, and these will be sent at the start of the month. Sometimes they will change during the month, and I will receive a rate to use for that currency onwards. The initial problem is that LastNonEmpty uses the granularity questioned, which means ...
For a Java application that drags data together from some sources and does some calculation itself, we want to offer users the possibility to use their own format strings, and would prefer the format string syntax they know from Excel (e. g. "$ "#,###.,0) which happens to be the same used in .net and Analysis Services. The closest thing...
What is the equivalent of RESTRICTED_USER database state in Analysis services? When we try to process OLAP cubes, it fails because of active user connections to teh cubes. Is there a way to restrict the user access to analysis services only to database administrators like we do in SQL server. ...
Hi I'm trying to enforce windows authentication for users of a .Net application on Web Server to access a cube on a Microsoft Analysis Services database on SSAS and just going nuts trying to get it to work! I am using <identity impersonate="true" /> in the web.config. Anonymous access is turned off in IIS and Integrated Windows Authen...
I'm currently building our Data Warehouse, primarily using Ralph Kimball's methods and guidance. We are using the Microsoft stack for this (so SSIS, SSAS). I am a bit stuck deciding how to handle BOMS (Bill of Materials) which is effectively an unbalanced hierarchy. The BOM handles assemblies which are a collection of parts. Each part...
I need to perform a calculation in SSAS which only applies to the current and future months (it can't be applied retrospectively using the available data). I can do this by using the calendar hierarchy and hard coding today's month as follows... SCOPE([Measures].[RollingStock]); ([Dim Date].[Calendar].[Month].&[201008]:NULL...
My fact table has a "Date" column that I have used as a foreign key to the Time Dimension table I used SSAS to create for me in the datasource. However when I deploy the cube and browse it, adding the time dimension attributes or any of its hierarchies do not filter anything on the measures. Its like there is a disconnect between the tim...
Hello, i'm new to Analysis Services. I have created a dimension on a boolean column. Now users want to have 'yes' and 'no' instead of 'true' and 'false' as result. Thanks. ...
I keep getting this error when trying to connect to an Analysis Services on the same machine the service is running on. If I connect via my desktop I don't see this error. I did quite a bit of googling, haven't found any solutions yet. When connecting from my desktop I am authenticated over a VPN. I get the feeling this error has somet...
I have a cube with a typical snapshot structure and daily granularity (like inventory quantities). I would like to be able to remove some of the granular data from this cube, because we have something like 270,000,000 rows of source data, cube processing is slow, and there isn't a meaningful difference from one data point to the next, at...
I am programmatically defining an OLAP cube (SQL Server Analysis Services) which imports measure groups and dimensions from two other cubes. How can I connect a dimension from one cube to a measure from another cube? ...
I have within an MDX query the following calculated member: MEMBER [Asset].[Class].[Fixed Income Derivatives (Inflation Linked)] AS ( [Asset].[Class].&[Fixed Income], [Asset].[Sub Class].&[Derivatives], [Asset].[Sub Class Type].&[Inflation] ) This is used within a query as follows: SELECT { [Measures].[Market Value] } O...
Hi, is there a free framework which I can use to develop a web analytics tool? We want to know how many people visit our site, which pages of our sites is the Most Popular and etc. like this: http://www.google.com/intl/en/analytics/tour.html Obviously, we do not need to analytize other sites but only our own site. BTW, we use tomcat ...