Stack Overflow
Stack Overflow

Questions tagged [analysisservices]

69 questions
6
votes
1 answer

Missing analysis service when creating new project

I have installed SSAS and created a project. After two months working with seas, now when creating a new project, the analysis service is not available. but I can open old SSAS projects. How I can create another new SSAS project.
Zahra
  • 317
  • 4
  • 16
2
votes
1 answer

Automate SSAS Tabular Model creation via script

I have a data catalog where people can browse through the DWH tables. People can select tables and send a request to the IT team. This is in the form of a table which gives all the table names and column names that a person wants to have. In the…
Jimmy Smeijsters
  • 135
  • 8
2
votes
4 answers

cannot deploy metadata. reason;an error occurred while connecting to server

I have made an Analysis service tabular project . now I wanna deploy the project but it gives the error cannot deploy metadata. reason;an error occurred while connecting to server. I checked the ssdt is installed. I don't know what else I have to…
Zahra
  • 317
  • 4
  • 16
2
votes
1 answer

to select top MAX 10 measure in mdx

I am trying to select top max 10 measure in MDX and I get this ,what I have to do to get top 10 max. With Set [Top10] AS (TOPCOUNT({ORDER( ({[Customer].[Customer State]}) ,([Measures].[Customers Quantity]),BDESC)},10)) Select …
Marim medhat
  • 39
  • 7
1
vote
1 answer

dax difference between filter vs filter values

Can someone explain how the first filter statement is different from second in DAX? FILTER(Table, Table[Column] = "some text") FILTER(VALUES(Table[Column]), (Table[Column] = "some text"))
Sivabose
  • 15
  • 1
  • 4
1
vote
0 answers

Unable to get period over period data from SSAS server using mdx query

Am using the MDX query in the SSAS server. I want to get the current year(01/01/2002 - 31/12/2002) and previous year(01/01/2001 - 31/12/2001) data for a specific date range(dynamically change) in a single MDX query based on the used measure and…
TAMILARASAN R
  • 225
  • 1
  • 6
1
vote
0 answers

DAX magic or new cube?

Is there a way to check from DAX, which Power BI report a user is opening? My problem is that I have a model with tables: -Revenue. -CostCenter. I have RLS set up for two special users: I take their USERNAME(), and I give these 2 users access to a…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1
vote
2 answers

DAX query with DISTINCT values, avoid repetition

I am doing a DAX query able to retrieve a list of products installed before a certain date (COIDate) , and that have a specific ProductLine. But, it returns the same product multiple times. I would like to know if there is a way, I'm sure there…
RobyB
  • 684
  • 2
  • 11
  • 19
1
vote
0 answers

How to run a DAX Query from java program?

DAX Query : evaluate ( summarize ( 'Internet Sales', 'Internet Sales'[Sales Order Number], 'Internet Sales'[Sales Order Line Number] ) ) order by 'Internet Sales'[Sales Order Number], 'Internet Sales'[Sales Order Line…
Myn m
  • 43
  • 8
1
vote
2 answers

"The server could not be contacted." error while deploying Model to SSAS

I am able to deploy model to SSAS from SSDT but when i try to deploy to SSAS with http enabled SSAS seerver by following below…
Myn m
  • 43
  • 8
1
vote
0 answers

Browsing SSAS Cube in excel - Pivot not giving expected layout

I have a dimension 'XYZ' with hierarchy up to level 7. When I drag level 04 of this dim (along with other dim) into pivot against measure value. I am getting below display. And this is expected result. Here I am connecting excel to cube from…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
1
vote
1 answer

SSAS Tabular Model - Query Mode with Partitions

I'm currently working on a tabular model project and I've been reading about the two modes for query mode: Direct Query and In-Memory. In the 2012 version for VS there's an option to deploy the solution in Hybrid mode (compatibility 1100 I think),…
Luis Molina
  • 11
  • 2
1
vote
1 answer

SSAS MDX Problem with IIF and TAIL() function

Experts, I am using SQL SSAS Std. 2017 and in the end want to create a calculated member that returns either the last month's day of my data or the current day if the last existing data is of today. (=> If today is Aug-31 I want to retrieve Aug-31…
Cordt
  • 49
  • 5
1
vote
1 answer

How to Encrypt Excel Connection String while connecting it to SQL server Analysis service?

I am pulling data from SQL Server Analysis service into Excel. I want Connection String To be encrypted. When I go to Data->Connection properties and click on save Password, I am able to see the password. Can any one Suggest me how to encrypt…
Chandu Nandina
  • 11
  • 2
1
vote
1 answer

SSAS MDX Previous Year - Ignore Filter

i try to get actual turnover and the turnover of the previous year in the same period. I write this query: with member [Measures].[Turnover PrevYear] as IIF( IsEmpty([Measures].[Turnover Actual] ), NULL, SUM( …
Alexo
  • 131
  • 4
  • 15
1
2 3 4 5