I would like to be able to query against an SSAS2008 instance and get a listing of all the catalogs that exist in it, as well as their respective storage sizes. In Management Studio, I can right click on the catalog and go to its properties, which retrieves this data, so I know it exists somewhere. A query that has some of the informat...
I have a number of stored procedures structured similarly to this: DECLARE @sql NVARCHAR(MAX) DECLARE @mdx NVARCHAR(MAX) CREATE table #result ( [col1] NVARCHAR(50), [col2] INT, [col3] INT ) SET @mdx = '{some dynamic MDX}' SET @sql = 'SELECT a.* FROM OpenQuery(LinkedAnalysisServer, ''' + @mdx + ''') AS a' INSERT INTO #result EXE...
I am trying to filter a query by two (multi select) parameters. It works fine when doing this for the first one, but complains when I add the the second one. Is my syntax wrong is there a better way to achieve what I want? ...
Hi, I need to modify the content of certain HttpRequests (SSAS connection strings) in IIS. Basically, I need to add an element to the SOAP contained in the request. My approach so far has been to add a Filter to the HttpRequest, and perform the change in the filter's Read method. As far as I can tell, though, Read is never being execut...
...
Can anyone tell me the site for getting SSAS 2008 and SSRS 2008 tutorial ? In PDF file if possible ? ...
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 am trying to update a SSAS 2005 cube adding a ragged hierarchy (it has a few levels that contain members that should be hidden if the member name is the same as the parent). From various sources I have read that I need to use MDX Comparability=2 within the connection string to see the HideMemberIf property. I have read so many opinion...
Hi! I try to fill a SSAS Mining Model with Data from a (local) SQL Server Table Both SQL Server and SSAS (all 2008) are on the same (devlopment machine) WinXP64. SQL Server Security is 'Windows Authentication' MDX Code: INSERT INTO MINING STRUCTURE [ttseries] ( [col1], [col2], [col3], [col4] ) OPENROWSET( 'SQLOLEDB', 'Server=(local...
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...
Is there any command or tool that can recreate the schema and fill the needed time data into the time dimension SQL Table for deployment reason? I'm currently facing the issue that only during designing the time dimension SQL Table the wizard is populating the table, afterwards there seems to be no way to invoke the same process again....
Using either a view and/or stored procedure, I can return the results of executing an MDX query against SQL Analysis Services (using OPENROWSET against a linked SSAS Server into SQL). Unfortunately, the resultset doesn't include a PK field...or for that matter, even a column which COULD act as a PK if I were to hack the model. Can an...
with member [Measures].[BoughtDispenser] as Sum(Descendants([Customer].[Customer].CurrentMember, [Customer].[Customer]), Iif( (IsEmpty(([Item].[ItemNumber].&[011074], [Measures].[Sale Amount])) And IsEmpty(([Item].[ItemNumber].&[011069], [Measures].[Sale Amount])) ) Or IsEmpty([...
Hi, I have a cube that I access via Targit (BI Solution). When I browse / use that cube I want all quantity results to be a zero if null / blank NOT a blank, but no matter what I try I get blanks. I have changed the Null Processing property for the measure in question as well as attempted to change / remove the format string. I still...
Does anyone know of a way to "extract" the formulas for all calculated members of a cube into some kind of flat, readable file? Alternatively, a less-painful method of getting an overview of the code than using Analysis Services' Cube Editor and clicking on each Calculated Member would be helpful. Yes, I'm new to MDX. Many thanks! ...
I have an SSAS cube with limited users. I don't want to grant any sort of access to the cube outside of those users. I have some SSRS reports that use the above SSAS cube as a data source. I want to give access to the reports to some users who don't have access to the cube. What credentials should I use for the cube data source? Since ...
I am in the process of designing a new customer fact and dimensions for my warehouse. In my search for good example models I noticed something odd. No one seems to have a customer-centric fact. Every example I found has a transaction event such as a sale or order as the central fact with customers as a dimension. This raises a question f...
Hi, Could anyone tell me to create SSAS partition dynamically? ...
In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data. I want to know if there is a way to view the MDX query being generated behind the scenes to display the data? Thanks. ...