SQL Server Analysis Services announcement
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Sticky2VotesBe our December TechNet SSAS Guru. Give the gift of code!
It's that time of the year again! It's Giving time! A time to think of those less awesome than you. A time to give ...2 Replies | 253 Views | Created by XAML guy - Tuesday, December 03, 2013 12:39 AM | Last reply by Ed Price - MSFT - Friday, December 13, 2013 4:24 AM
-
Unanswered0VotesReporting action with a parameter
Hi, I am having an issue setting up a reporting action with a parameter. The report I am trying open is non-cube based database report. I tried a few syntax ... -
Unanswered0VotesAssemblies folder is showing empty
Hi, I am checking SSAS server and seems Assemblies folder is empty...I am facing such issue for the first time. Do anyone know if you have such issue earlier because I want to use ...1 Replies | 76 Views | Created by Aniruddha Thengadi - Tuesday, December 17, 2013 3:30 AM | Last reply by Charlie Liao - 37 minutes ago -
Unanswered0VotesRelated column of a fact table - SSAS Tabular
Hi, I'm developing a SSAS Tabular model using a SQL Server 2012 SP 1 installation. For a fact table I've created some calculated columns using the DAX RELATED ... -
Unanswered0VotesSAS create a New Named Set
I was trying to create a new named set on SSAS : Exists([Dim Device].[Browser Name].[Browser Name].members, [Dim Device].[Platform].&[android] ... -
Unanswered0VotesMigrate SQL 2008 Analysis database to 2012 AS database along with data level security defined in current production cube
I want to migrate Analysis Services 2008 database to 2012 AS database along with data level security defined in current production cube Note: Only Production environment have ... -
Unanswered0Votescreate single-value measure from a measure array
I need some education on MDX.. :) I have Measure A which gets calculated across Dimensions Dim X, DimY and DimMonthly. is there a way or maybe function to create Measure B ...1 Replies | 94 Views | Created by BrBa - Thursday, December 12, 2013 3:07 PM | Last reply by Serena Williams - 1 hour 5 minutes ago -
Unanswered0VotesUsing IF or SWITCH functions inside a DAX formula into a tabular model - SSAS 2012
Hi, in a tabular model I've changed a DAX formula introducing the SWITCH function, but when I deploy the changed formula and open the Excel workbook the slicer connected to the ...2 Replies | 81 Views | Created by pscorca - Monday, December 16, 2013 3:56 PM | Last reply by pscorca - 1 hour 20 minutes ago -
Unanswered0VotesEffectiveUserName for Excel Services data connection to SSAS 2012 Tabular model from SharePoint 2013
After following the steps from this site http://technet.microsoft.com/en-us/library/jj938164.aspx I am still unable to configure the EffectiveUserName Functionality. ...1 Replies | 72 Views | Created by Andrew.Alexander - Monday, December 16, 2013 5:38 PM | Last reply by Elvis Long - 1 hour 24 minutes ago -
Unanswered0VotesRunning out of disk space
Hello A folder (shown at the bottom of this post) on our SSAS 2008 R2 contains 70 GB of data! The biggest files ... -
Unanswered0VotesSSAS using datasource at query time
I have a set of reports that run against the cube. The cube has proactive caching enabled. If the datasource within the SSAS database has invalid credentials, queries against the cube will ...3 Replies | 145 Views | Created by Tha_Tyrant - Thursday, December 12, 2013 4:13 PM | Last reply by Elvis Long - 3 hours 58 minutes ago -
Unanswered1VotesCustom ADO.NET implementation for Analysis Services
Hello, I need help on guidelines implementing custom ADO.NET data provider and connecting it with BIDS. While the first part is rather straightforward and documented, I'm struggling a lot with ... -
Unanswered0VotesHow Can Use varchar measures in cube
Hi Dears Please help me as soon as possible. I define a Named Query on 3 dimension tables .the miladidate field as a date and the MonthName field as a varchar, do ...1 Replies | 67 Views | Created by NafisehPanahi - Tuesday, December 17, 2013 12:02 PM | Last reply by Charlie Liao - 5 hours 43 minutes ago -
Unanswered0VotesMDX:Work with date in ssas cube
Hi Dears. as you see my data (by date format ) in data warehouse is correct but when i deploy cube in SSAS 2008 , the data is corrupted. Please help me as ...3 Replies | 95 Views | Created by NafisehPanahi - Monday, December 16, 2013 5:52 AM | Last reply by Charlie Liao - 5 hours 44 minutes ago -
Unanswered0Votesis SSAS the right tool to replace SAS Enterprise Guide?
I am in the process of studying the feasibility of replacing one of our custom built SAS Data Warehouse with Microsoft BI/DW stack. I have one specific question that I ...2 Replies | 95 Views | Created by hommer - 23 hours 2 minutes ago | Last reply by Raunak J - 5 hours 58 minutes ago -
Proposed0VotesWhat is the difference in Microsoft.AnalysisServices.AdomdClient.dll under C:\Program Files and C:\Program Files (x86)?
What is the difference in c:\Program Files (x86)\Microsoft.NET\ADOMD.NET\110\Microsoft.AnalysisServices.AdomdClient.dll and c:\Program ...1 Replies | 66 Views | Created by tballard - 23 hours 20 minutes ago | Last reply by Charlie Liao - 7 hours 10 minutes ago -
Unanswered0VotesMDX error in calculated member
I want to include in the calculated member expression the following: If the status =1 and substatus= 1 then do the calculation only for this pair. I got this ... -
Unanswered0VotesReport action Parameter issue while SSRS report hosted in Sharepoint environment
Hi All, I am facing a issue that the MDX query is not getting executed. If we pass the parameter value with out double quotes(" ") The link in excel reports becomes ... -
Unanswered0VotesQuery Performance Issues on a cube sized 64GB.
Hi, We have a non-time based cube whose size is 64 GB . Effectively, I can't use time dimension for partitioning. The transaction table has ~ 850 million records. We have 20+ ... -
Answered0VotesXMLAnalysis Error while trying to execute a MDX query on MS SSAS - Accessing the cube from Java through Olap4j driver
Am trying to access MS SSAS data cube from Java through olap4j driver(through msmdpump.dll). I am able to connect , but when I try to execute a query, i am getting the below error: Please ...1 Replies | 58 Views | Created by Boni K - 17 hours 51 minutes ago | Last reply by Darren Gosbell - 12 hours 5 minutes ago -
Answered1VotesErrors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated.
I'm receiving this error. Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being ...3 Replies | 4710 Views | Created by Andrew Geer - Friday, January 22, 2010 4:16 AM | Last reply by Rag.S - 12 hours 43 minutes ago - Items 1 to 20 of 33075 Next ›


