Analysis :: Can Applications Connect To SSAS Tabular Mode Cubes Through ODBC Drivers?

Aug 26, 2015

Can applications connect to SSAS Tabular mode cubes through ODBC drivers? I have been asked the question specifically regarding SAS, and I can see (for example) SAS Enterprise Guide has the ability to connect to sources via ODBC, so I now need to find out if there are such things as ODBC divers for SSAS (specifically Tabular).

View 3 Replies


Analysis :: SSAS 2014 - How To Change Mode To Tabular

Nov 13, 2015

I have a new 2014 SSAS installation.  During VS2013 Tabular Project create I get an error Cannot connect, Reason The workspace database on server ***** is not running in tabular mode.I've changed    msmdsrv.ini  - DeploymentMode>2...The server wont start.

View 3 Replies View Related

Analysis :: SSAS Tabular Model In DirectQuery Mode Clients

Jun 27, 2015

I'm working on a Tabular model at my job since the users have a requirement to query against a live data source. I've been looking online for clients that issue DAX as opposed to MDX to the model, but besides SSRS and Power View, I could not find anything else. Any other client side interfaces to a DirectQuery Tabular model?

View 2 Replies View Related

Analysis :: Adding KPI To SSAS Tabular Perspective

Aug 1, 2012

SQL Server Data Tools within VS 2010 Shell.2012 SASS in Tabular Mode.I've created a Measure and KPI in my fact table.  I've created a perspective named "Summary"  When selecting the fields and measures for display in the perspective, the measure is available, but not the KPI (target, status, etc.). When Analyzing in Excel with the Summary perspective, the KPI is not available in the field list. When analyzing in Excel with the (default) perspective, the KPI is available.As far as I can tell, there is no way to select a KPI within the perspective window. 

View 8 Replies View Related

Analysis :: SSAS Tabular Stand Alone Table In Excel

Jul 16, 2015

I am working with SSAS Tabular. I have a stand alone table with 60 columns and contains 120K records. Table size is 250MB. And trying to build a tabular report out of it and it is taking longer and throwing exception, screenshot attached.

It might be cross-join issues, as workaround created a dummy measure and using in report. But it working for 10-20 k records and beyond throwing same exception. I have 8 GB RAM and 100 GB free disk space.

Customer wanted it in SSAS Tabular...

View 3 Replies View Related

Analysis :: SSAS Tabular And SSRS - Implementing Security

Oct 1, 2015

i would like to pose a question, when a user do a login in SSRS server,is  it possible to pass the username to SSAS tabular, to implement security? I've tested using USERNAME() creating a role that relates USERNAME() with a dim user username, but now i need to implement it with the username used in SSRS server. 

View 2 Replies View Related

Analysis :: SSAS Tabular - Preview Of Calculation Not Working

Oct 30, 2015

Does any1 know why preview of a DAX calculation does not work? I mean once you enter the calculation in the bottom of the table it doesnt´t show up.

View 8 Replies View Related

Analysis :: Processing SSAS Tabular Model Automatically

Oct 18, 2012

how can i automatically update my tabular model in the future when there's an update in my database.

View 4 Replies View Related

Analysis :: SSAS Tabular - Grouping In Excel Grayed Out?

Nov 10, 2015

I have a Tabular data model and I'm returning a measure that counts employees (each row is an employee) and then a calculated column in the model that gets SeniorityInMonths.

So if an employee was hired exactly 1 year ago, they would have 12 in this column.

I want to group these into bins, but the Group option is grayed out.

View 6 Replies View Related

Analysis :: SSAS Tabular Model Processing Error

Nov 4, 2015

I get the following error while processing a SSAS tabular model (2014) on a new server.The SSAS service on this server is running under a login which has access to the SQL server data sources. I tried changing the provider to OLEDB from SQLCLNI11 in the connection string but that doesn't work too. The error message isn't useful to debug further.

The cube processing succeeds on a different server. I scripted out the cube DB and ran it on the new server and am trying to process full but it fails with the following error.

Error Message:
The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source.

More Details:
OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections.

For more information see SQL Server Books Online.; 08001; SSL Provider: No credentials are available in the security package

; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
A connection could not be made to the data source with the DataSourceID of 'd7a37dae-be87-44e0-a8b2-498069af82c9', Name of 'connection name'.
An error occurred while processing the partition 'XXXX_460f3467-1a99-4dc9-aaf2-bcf3d54a5c4c' in table 'XXXX_460f3467-1a99-4dc9-aaf2-bcf3d54a5c4c'.

The current operation was cancelled because another operation in the transaction failed. The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source.

View 3 Replies View Related

Analysis :: SSAS DAX - Tabular Model Deployment / Given Key Was Not Present In Dictionary

Jun 2, 2015

We are working on implementing DAX formula(s) on our tabular model (SSAS 2012). When we tried to deploy the solution, deployment wizard giving us then below error:The given key was not present in the dictionary...I checked all the formula(s) that we recently implemented and all looks fine.

View 4 Replies View Related

Analysis :: SSAS - Time Intelligence Is Not Working In Tabular Model

Apr 17, 2015

I have a separate date dimension marked as Date table in Tabular Model and having proper relationship with another table(e.g SalesTable) with column of date type. But still time intelligence functions are not working. I am using the date column from other table (e.g SalesTable) in the formula. What exactly going wrong in our tabular model.

View 3 Replies View Related

Analysis :: How To Extract Data From SSAS Cubes Into A Table

Jun 19, 2015

I need to extract data from SSAS' cubes into a SQL Server table.

I already read examples using Linked server (with openquery), SSIS, etc. However, the result always return as many columns per dimension as levels. I need to extract all members of a dimension in a column. E.g., when excecuting the following MDX query in Adventure Works 2014:

select [Measures].[Sales Amount] on columns,
       Non Empty [Date].[Calendar].members on rows
  from [Adventure Works]

I would like to get this result (MDX query in SSMS), but with keys displayed intead of names:

But I get this (MDX thru openquery or SSIS):

View 4 Replies View Related

Analysis :: Creating Cubes In SSAS Using Various Tables In Excel

Jun 29, 2015

I'm exploring creating local cube files, .cub from an excel sheet with tables.Would SSAS be able to create one cube from taking data from a 1 way table (A, B, C), a 2 way table (AxB, BxC, AxC) and a 3 way table (AxBxC)?

View 4 Replies View Related

Analysis :: SSAS Tabular Missing Data Column Doesn't Deploy

Aug 2, 2015

I have created a tabular model with VS 2013 Ultimate. I deployed the model several times and everything works great with Power Pivot.

One of the dimension tables, "Age", has an integer field that is null. I updated that column in SSMS to have values, processed the table in VS and the "Age" column now has integer values.

I deployed the model again, connected with Power Pivot, and the "Age" column still has not data. I refreshed the Excel spreadsheet several times, started a new one, deployed several times and there is still not data in the "Age" column even though it clearly exists in VS.

I opened SSMS on the Analysis Service and queried the table in question and it also shows no data in the Age column even though it is in the data table and the VS model.

I can't find anything different about this column than others that contain data. How can this be happening?

View 2 Replies View Related

Analysis :: SSAS Tabular And Multi-dimensional Instances Using Same Server Instance?

Aug 27, 2015

Is it possible to install 2 SSAS instance (one default and one named) and have them access a single sql server instance (default) all on the same server?

View 3 Replies View Related

Analysis :: SSAS Tabular - Dynamic Security Roles - Mixing Together DAX Filters

Oct 10, 2015

I have two different roles, each one with a dax filter. One is for filtering users that access by Excel, and other for filtering users that access by Reporting Services, respectively:


To create only one role that serves Excel and Reporting Services users, is it viable to use only the || (OR) operator?, is there any other regard i should take?

View 2 Replies View Related

Analysis :: How To Use Stored Procedure In SSAS To Combine Result From More Than Two Cubes

Jul 15, 2015

I have two cube and i would like to get data from both cube and combine the results from both cubes to get final result to display result in SSRS reports like we can do in Stored procedure using temporary tables/Joins.Is there any way in SSAS to combine the data from multiple cubes? Data needs to be retrieved from the cubes based on the user inputs.

View 3 Replies View Related

Analysis :: Show Grand Total When Using SSAS Tabular Role Security Permission

Oct 30, 2015

If user want to see the grand total for a measure with include all members, even though the user has limited access for that member, so how we can do using DAX?For example, let’s say the total revenue for all the divisions in a cube is $15,000. You create a role called “Division A”, and set it up so members of that role can only see the revenue for Division A, which totals $3,000. If you use a front-end tool like Excel to access the cube and use the division hierarchy to see the total revenue, you will see the revenue of $3000 for Division A, but also want to see the Grand Total for the revenue as $15,000How we can achieve above scenerio in tabular model (DAX).

View 3 Replies View Related

Analysis :: Tracking Information About No Of Connections Made To SSAS Cubes Through Excel Files

Sep 29, 2015

Is there any way to track the information about the  connections to SSAS cubes through local  Excel files (BI usage).

OPreviously, we are tracing the information about the BI usage through the BI SharePoint site. Now we want track the users who are using through local excel files .

View 9 Replies View Related

Analysis :: SSAS Tabular Small Database Fails In Excel Pivot Table Because Of Memory Shortage?

May 7, 2015

I have a very small SSAS database with around 35 Mb. I opened it on Excel 32 bits and started dragging fields to a pivot table and it started failing with memory errors. The behavior on the SSAS server was that memory started growing very fast until 8 GB (vm memory total) and then the error is reported in excel.

What might be the issue in such a small database? I would understand in a big database, but not on this one.

View 13 Replies View Related

Analysis :: Where Are Tools To Allow To Connect To Server And Work With Tabular Models

Jun 10, 2015

I see we can install SQL Server 2016 CTP2 and Tabular SSAS.However, where are the tools to allow us to connect to the server and work with the tabular models?Supporting features such as bi directional filtering, etc..The existing SSDT BI tools for 2014 don't contain those additional features (editing relationship filtering direction for example).

View 2 Replies View Related

Analysis :: How To Connect SSAS Cube To Server

Jun 12, 2015

How can I connect ssas cube to server. I have no SSAS SERVER INSTANCE...

View 3 Replies View Related

Indexes Within SSAS Cubes

Sep 11, 2007

New to SSAS so, have some not so intelligent ???

We have created Dimensional Model within SQL 2005 and created SSIS packages to load. We have Pk's on Dimensions and FK's on one Fact table. We are thinking about adding clustered index to Fact that consists of the FK's and order by the Hierarchy within the Fact by Dimension. IS THIS A GOOD IDEA IF WE DRILL DOWN AND DRILL THROUGH = QUESTION #1


THank you

View 5 Replies View Related

SQL 2012 :: SSAS Tabular Model - ADD Column Option Grayed Out

Mar 29, 2015

I am trying to learn building SSAS tabular model. While following a tutorial I need to add a column to an existing table but for some reason the ADD Column option (insert column in other menu is also not appearing) is greyed out.

View 4 Replies View Related

Power Pivot :: How To Load SSAS Tabular Database Tables

Aug 19, 2015

I am trying to implement some powerview report in excel 2013 itself (not in sharepoint).

I have implemented a SSAS tabular model and deployed to server. Now my aim is to load this tables in the SSAS tabular database into powerpivot so that i can use this data for creating powerview reports. However when i tried to import data from SSAS, it asks database and MDX query. My requirement is to load the dimension and fact tables to power pivot as it is.

View 7 Replies View Related

Power Pivot :: Define SSAS Tabular Measures In Batch?

Nov 19, 2015

We have an Excel PowerPivot model that we are trying to move to SSAS Tabular. The model is complex and has over 300 measures. To group these in Excel, we pasted in dummy tables and defined the measures in logical groupings. Now when we are migrating to SSAS, we have to delete the pasted tables --that have ALL of the measures, in order for the import to work successfully.

How to migrate the model? We have a nice report of all of the measures from DAX Studio, but I am not looking forward to manually re-entering 300 measures through the user interface. Is there any way to define measures in batch? Or is there a way to change the pasted table to a file so the import will work? Will the import work in SSAS 2016?

View 3 Replies View Related

Reporting Services : Report Using Two Datasets From Two SSAS Cubes

Mar 5, 2008


I would like to build an SSRS report from two different cubes (SSAS 2005). These cubes are contained in two different SSAS databases.

To do this, i created a dataset for each cube throught MDX expressions.
These datasets use common parameters defined in my report.
Thus, i try to integrate in my report chart datas from the two datasets, but my chart only target one dataset.

Is it possible to create a kind of dataset view to join my two datasets ?
Or is it possible to join the cubes from two different SSAS databases in an MDX expression to put all my datas in a single dataset ?

thx for your help.


View 3 Replies View Related

SQL 2012 :: Applications Cannot Connect Because Logins Cannot Connect To Their Default Databases

Oct 17, 2014

I designed the AlwaysOn wrong, but every time we fail over from primary server to another server, my applications cannot connect because the sql logins cannot connect to their default databases. Once I run the command to link the login with the user in the default database then the users are able to connect. Did I do something wrong when designing AlwaysOn?

View 9 Replies View Related

Power Pivot :: Update Error (works If Importing Into SSAS Tabular)

Jun 25, 2015

The thing is I can´t make update powerpivot, it raises a generic error. Tried to import into ssas tabular and worked fine.

Is there any way to get a better error detail or debug it someway?

View 4 Replies View Related

ODBC Drivers

Jan 28, 2000


I have an ODBC question. They say that to use SQL server 7.0 'tools', one must use ODBC 3.70 drivers. Is there anywhere where I can find a list of these 'tools' that will need these drivers?


View 1 Replies View Related

Need Help For ODBC Drivers

Jan 11, 2008


Will 32-bit ODBC Drivers work in 64- bit machine? I have already installed 32-bit ODBC drivers in 64-bit machine so i wanna make sure all applications work fine.

ALSO, Where can i get to download ODBC Drivers for
1) Oracle in Orahome 92
2)Sybase SQL Anywhere 5.0
3) Informix 3.8 32 bit
4) openlink

Is there any 64-bit drivers available for above ODBC Drivers?
PLease Help.Thanks

View 1 Replies View Related

ODBC Drivers

Jan 30, 2008

Okay, this is a weird question/problem. I have a 64 bit database server running on 64 bit Windows. This is just fine until I moved a 32 bit database over to it. My DB is trying to get some reporting to work and discovered that there are no ODBC drivers for Excel on this new 64 bit box. Are there 64 bit drivers for MS Excel? And access for that matter? If so, where are they?


View 4 Replies View Related

Copyrights 2005-15, All rights reserved