Questions tagged [ssas-2016]

19 questions
0
votes
1 answer

How to add calculated member which shows total Gross value?

How can I add calculated measure in SSAS which shows in attached image? Image
Nikunj
  • 31
  • 1
  • 4
0
votes
0 answers

SSAS Error encountered in transport layer after saving and opening the file

I am experiencing a really strange problem: When I connect to SSAS on an Azure VM everything works nicely the first time, I can create pivot tables using this connection. Then I save the file and open it another day and I can't connect anymore…
analyzethat
  • 191
  • 1
  • 16
0
votes
1 answer

SSAS 2016: "The attribute key cannot be found" error, when processing a dimension after adding an attribute

Suppose I have a dimension DIM_Users with two attributes UserId [bigint] and Reputation [int]. In this case I can successfully process the table. But, after I add DisplayName [nvarchar(255)] attribute to the dimension, processing fails with the…
Andrey Morozov
  • 7,839
  • 5
  • 53
  • 75
-1
votes
1 answer

HR Cube in SSAS

I have to design a cube for students attendance, we have four status (Present, Absent, Late, in vacation). the cube has to let me know the number of students who are not present in a gap of time (day, month, year, etc...) and the percent of that…
whd.nsr
  • 684
  • 6
  • 12
1
2