SQL Server Analysis Services announcement
Categories
-
Select allSQL Server Data WarehousingSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server SearchSQL Server SpatialDatabase DesignSQL Server Master Data ServicesSQL Server ManageabilitySQL Server PowerPivot for SharePointSQL Server PowerPivot for ExcelSQL Server Application and Multi-Server ManagementSQL Server Samples and Community ProjectsMicrosoft StreamInsightSQL Server MigrationSQL Server Data Quality ServicesSQL Server Distributed Replay
-
Select allSystem Center Mobile Device Manager
-
Select allBizTalk Server GeneralBizTalk Server Adapters and Adapter PackBizTalk Server EDI and AS2BizTalk Server RFIDBizTalk Server Host Integration Server
-
Select allExchange Server 2013 - General DiscussionExchange Server 2013 - Administration, Monitoring, and PerformanceExchange Server 2013 - High Availability and Disaster RecoveryExchange Server 2013 - Outlook, OWA, POP, and IMAP ClientsExchange Server 2013 - Mobility and ActiveSyncExchange Server 2013 - Setup, Deployment, Updates, and MigrationExchange Server 2013 - Extended Components, Tools, and UtilitiesExchange Server 2013 - Mail Flow and Secure MessagingExchange Server 2013 - Unified MessagingExchange Server 2013 - Sharing and Collaboration: Site Mailboxes and Public FoldersExchange Server DevelopmentExchange Server 2013 Preview (locked)
-
Select allTechNet Website FeedbackMSDN and TechNet Search FeedbackTechNet Wiki Discussion
-
Select allForefront Identity Manager 2010
-
Select allMicrosoft Operations Framework -- MOF 4.0
-
Select allIT Management Planning and Technology
-
Select allTraining and Certification
-
Select allLive Meeting General DiscussionLive Meeting - Creating, Joining Meetings, Configurations and SettingsLive Meeting - In Meeting Experience, Console and Add-insLive Meeting - Media DiscussionLive Meeting - Rollout/Deployment Programs
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesAre you a technology guru? Show us your solutions and become the Analysis Services Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert or authority on SQL Server Analysis ...
-
Unanswered0Votes
SSAS...Seperate Date and Time tables for date time dimension
Hi I have one datetime table and have a date time dimension on it. But I want to split my tables to date and then another one in time. Can someone help me with forming a dimension ... -
Unanswered0Votes
HOW TO FORMAT AND SET-UP TO IMPORT ASCII CALIF CORP FILE BY CALIF SECRETARY OF STATE?
Dear Sir: I purchased a California Corporation file (3 Million records) from California Secretary of State. It is a ASCII format. I used a column import with fixed width (SQL ... -
Unanswered0Votes
HOW TO FORMAT AND SET-UP TO IMPORT ASCII CALIF CORP FILE BY CALIF SECRETARY OF STATE?
Dear Sir: I purchased a California Corporation file (3 Million records) from California Secretary of State. It is a ASCII format. I used a column import with fixed width (SQL ... -
Unanswered0Votes
calculated measure using Current time
Hi, I have a situation, where I need to calculate difference between given datetime(field in my fact table) and current datetime . I need calculated ... -
Unanswered0Votes
Publishing an Excel workbook connected to a SSAS Tabular model
Hi, I need to know if it is enough to have SharePoint Server 2010 + Excel Services to publish an Excel workbook that points to Tabular model, without installing PowerPivot for ... -
Unanswered0Votes
Setting up a Sharepoint 2013 BISM data connection to use a tabular model perspective
I am trying to establish a data connection in Sharepoint 2013 to a tabular model in SSAS 2012. Is there a way to specify that a particular perspective should be used? I cannot see how this would be ... -
Unanswered0Votes
Count Customers by Sales
=250000,1,0)) If I pull in the customer ID into the rows of the pivot table, the calculated member will correctly flag any customer IDs that have sales in excess of $250,000. However, ... -
Unanswered1Votes
Does Slowly Changing Dimension Wizard in SSIS 2008 work with SSAS 2008?
So I am working on my second cube. In the first I used a naturally occuring key to link my dimensions and fact tables together. For my second cube, I am trying to develop more ... -
Unanswered0Votes
Cache Warmer How to Code it
Hi every one So I am learning this cache warming optimization technique, I checked lot of links but didnt find some help in how to write the code for ... -
Proposed0Votes
Unable to add users to SSAS role
I can give user MyDomain\ABSmith access to SSDS by giving him a login and assigning him to the requisite SSDS groups/roles. I cannot: Create a ... -
Unanswered0Votes
On random day processing is taking long to complete
Hi, I'm facing a weired issue on production server where on some random day processing takes long to complete the processing. Usually cube processing takes 10 mints, but on some ... -
Unanswered0Votes
Distinct count measure Funny output
I created a measure with distinct count on one of the column of fact table. I get count as 776 whereas it should be in millions. Can someone ... -
Answered0Votes
ssas Aggregation design wizard
Hi everyone What is aggregation design wizard, does it help with precomputing the aggregations. If it does, how? and what options I need to select to precompute ALL aggregations ... -
Unanswered0Votes
Ordering Measures in SSAS Tabular Model
How can measures be ordered in a particular order for better user experience of adhoc analysis using Excel 2013? The OOB just orders it alphabetically and I don't like the idea of prefixing 1,2,3 ..to ... -
Unanswered0Votes
GL Cube Chart of Accounts Multiplier
We’re modeling a General Ledger cube. For the most part it’s pretty general and simple. We’ve got Time, Chart of Accounts, and Accounting Unit ... -
Unanswered0Votes
Appending a string in MDX
select [Age Band].[Age Band].[Band].members on rows, [Measures].[unt] on columns from [Cube] I need to apend a string 'Age ' to [Age Band].[Age ... -
Unanswered0Votes
DAXMD: Selecting a Dimension with UnknownMember results in permanent 25% CPU Usage
Hi, I'm using the CTP of DAXMD. When I'm selecting a specific Dimension as Filter in Powerview, the the CPU usage inrease to 25 % permanently and I get no results. Only Solution was ... -
Answered0Votes
Referenced Dimension, Many-to-Many Relationship, or something else?
My question would be easily understood if there was an accompanying diagram, but unfortunately I don’t know how to upload pictures here. Well – I will try my best to explain my ... -
Answered1Votes
MDX query help
Hi All, I am having issues in writing an MDX query for the below scenario.As I am new to MDX it is getting diffcult to work on the below ... -
Unanswered0Votes
Setting All level to null on selected measures without impacting other hierarchies
I have a requirement to set the All level to null for specific measures sliced by specific dimensions. This code does the trick for the dim in question, but when the dim is not part of the ... - Items 1 to 20 of 31299 Next ›
.png)
