Drag and drop will not work in SSAS Cube

Hi,

Today my trainees faced a strange issue, they were trying to drag and drop the deployed dimensional attribute in the cube browser and they were not able to do so. They also tried to right click on the attribute name and click on "Add to row" but it would fail.

To resolve this issue, I checked the server to which thier cubes were connected, i,e the Analysis services server. It was disconnected. when I reconnected it and asked my trainees to redploy, reconnecr and refresh, they were able to drag and drop attributes like before

SSAS - Grand total value is repeating or it is the same for every measure value

Hi,
I was teaching MSBI to my trainees and I noticed that the in the cube browser the Grand total value is repeating for all its measure values as shown in the below picture.

To resolve this error check your dimension structure under "Cube Structure" tab. Check if the dimension you are dragging and droping is diretly related to your fact table. If not then establish the relationship by clicking on "Dimension Usage" tab. I added the referenced relationship and bingo, it worked

Not getting unique values in Hierarchies - in dimension browser

Hi,
I was trying to create the DIM Geography using listed in Adventures Works DW and when I deploy this the browser will show me so many Country names as shown in the below screenshot

After worrying my head a lot on this issue, I realised that this happened as I had set key column even for EnglishCountryRegion name. Hence to resolve this issue, I came back to "Dimension Structure" tab>right click on "English Country Region Name">Click on properties>Come to "Keycolumn" and remove any other attributes added and make the EnglishCountryRegionName to be uinque. Check the below fig

 Deploy and then reconnect to get the final result

Trust relationship between the primary domain and trusted domain failed in analysis services

Hi,
I was teaching MSBI to my collegues and I could not make them deploy thier analysis services project on my server. I figured that I have to add thier names as admin and when I tried to do it, I get the above listed error message. To resolve this error message follow the below steps:

Right click on Analysis services server name >Click on Properties
Click on Security tab at the bottom.
If you are getting this error message then you should see the below screen

Delete the entry highlighted in yellow.
Now you would have lost your admin rights too..so quickly enter your login details to gain the admin rights . i,e click on ADD and then enter your own login details

Now continue adding other admin details

Bingo!!...It's working