Hi
When I try to create a ssas tabular project in ssdt I get the following error.

You are not an Administrator on the workspace database server (Servername).

Any suggestions?

how do I join two queries, join them HORIZONTALLY, i.e. extra columns, second columns query 2 to right of first query



--query 1 OUTPUTS
SELECT a.timeStampKey, t.timeStamp,MAX(CASE WHEN a.PIE2_O_ID = 1 THEN value END) AS 'K_DESIGN_SG_A_AVERAGE_A', MAX(CASE WHEN a.PIE2_O_ID = 2 THEN value END) AS 'K_DESIGN_SG_B_AVERAGE_B'FROM   tblOutputs as a INNER JOIN       tblTimeStamp as t ON a.timeStampKey = t.timeStampKey GROUP BY a.timeStampKey, t.timeStamp
--query 2 INPUTS
SELECT a.timeStampKey, t.timeStamp,MAX(CASE WHEN a.PIE2_I_ID = 10104 THEN value END) AS Flow, MAX(CASE WHEN a.PIE2_I_ID = 10006 THEN value END) AS Head FROM   tblInputs as a INNER JOIN       tblTimeStamp as t ON a.timeStampKey = t.timeStampKey GROUP BY a.timeStampKey, t.timeStamp

I'm new with SQL Server, but am pretty skilled with BI tools using Power Query & Power Pivot and such.  To learn more about the upward limits of Power Query and to get to know more about SQL Server Analytical Services (SSAS), the Tablular model and SQL Server Data Tools (SSDT), I started a self-learning project using a large CSV dataset from the US Dept of Ed, with 1900+ columns, 98000+ rows (dataset is publicly available).   I found Power Query does a nicer job of parsing raw CSV data into correct columns than the SQL Server import/export wizard, and has fewer constraints.  For example, Power Query can handle sets with > 1000 columns.  Most of the USDeptofEd data columns contain values that can be unpivoted; doing so creates a file with 18 columns but with over 185 million rows!  So it seems best to load this data into a proper SQL Server database with tables.  Of course, to get SSAS to accept Power Pivot data model I had to split the tables into 2 so none had more than 1000 columns - which I did.  I successfully imported the data into a SSAS Tabular solution using suggestions at this this OakTree post.  This was all done on a i5-2320 3GHz 64 bit processor running on Windows 10 with lots of unused storage, but 8GB of RAM.  

Here are a few screen shots so you can see what's going on:Power QueryPower Pivot - Data ModelVisual Studio
Questions:
1. Can anyone tell if my data is optimally stored in SQL Server? …

Hello

I have a simple MDX cross join that produces the following result

select crossjoin (   {[Product].children}  ,{ [Measures].[Actual], [Measures].[Plan] }  )
ON Columns,
[Region].children on Rows
From [cube]

eg product 1   product 1     product 2  product 2
     Actual         Plan              Actual        Plan


I want to combine the member names from the 2 column dimensions into one name, to look like a relational grid
eg product 1 - Actual    product 1 - Plan       product 2 - Actual    product 2 - Plan


The Products are dynamic - the Measures can be hard coded.

Has anyone got a head start on how I may be able to produce the flattened output?

Thanks
John

I have a DSV that is made up of my Fact table and Dimension tables. Im kinda new to this(I was able to do this years ago). I remember being able to process a cube and browse the data in my tables. I know I will be missing a lot of pieces of code but for now I am just trying to give my boss a proof of concept. Which means if I can somehow show him the data and the ability that SSAS has to save time on reporting rather than write ad-hoc reports than I can go back and do this the correct way. Like I said, I just have to be able to browse the data that consists of the data in the Dimensions shown below. My problem is I cannot Process the cube without getting errors. I have a small star schema consisting of a Fact table that is loaded and the Dimension tables that hold the lookup data. All I want to do at this point is show the data By Carrier Name with the TXN_01-TXN_15(Column fields are defined in another lookup right now) aggregated. Literally that is all I need at this point. Can someone help me with this? The pic embedded is my data source view and when I try to Process the cube with the suggested files I get the following errors.....

 
Again,I know I am not doing this correclty I just need to be able to show the data so I can rewrite this the correct way and trust me I will be coming back to this site for more help!!

The following is  what I want to be able to show my manager with the data I have in my Dimensions...Sorry for the editing I just …

Hi Experts ,

  Issue : Linked Server is being created but no catalogs are found when accessing the SSMS (Sql Server Management Studio) with SQL Authentication but with Windows Authentication , I can access the catalogs.



Please Note : WH DB Server /Cube Server / Linked Server are on the same machine.

Here is the code , how I am trying to create a linked server and catalogs .

Please help me with the solution , will appreciate your help in this regard.


if NOT exists (select srvname from master.dbo.sysservers where srvname = 'RPM_Cubes')
BEGIN
Exec master.dbo.sp_addlinkedserver
@server = N'RPM_Cubes',
@srvproduct ='',
@PROVIDER = N'MSOLAP',
@datasrc=N'localhost\sqlserver2016',
@catalog ='RPM_Database'
EXEC master.dbo.sp_serveroption @server=N'RPM_Cubes', @optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'RPM_Cubes', @optname=N'rpc out', @optvalue=N'true'
END
ELSE
 PRINT 'Link Server already exists'


Thanks,
SRK.

Hi Experts ,

  Issue : Linked Server is being created but no catalogs are found. I am trying to access the SSAS Cubes using the  MSOLAP provider as mentioned below.
Please Note : WH DB Server /Cube Server / Linked Server are on the same machine.

Here is the code , how I am trying to create a linked server. Please let me know if I have to configure any server options to create the catalogs in linked server.

if NOT exists (select srvname from master.dbo.sysservers where srvname = 'Test_Cubes')
BEGIN
Exec master.dbo.sp_addlinkedserver
@server = N'Test_Cubes',
@srvproduct ='',
@PROVIDER = N'MSOLAP',
@datasrc=N'localhost\sqlserver2016',
@catalog ='Test_Database'
EXEC master.dbo.sp_serveroption @server=N'Test_Cubes', @optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'Test_Cubes', @optname=N'rpc out', @optvalue=N'true'
END
ELSE
 PRINT 'Link already exists'


Thanks,
SRK.

Hi I have a cube that I have setup a Report Action on that opens an SSRS report that contains a parameter of @JobNumb.  The SSRS Report is based on a database, NOT a cube.  I can get the Action to appear on the menu when I test the cube in Excel and open the report is SSRS, however I am struggling to pass the parameter over!  I have tried several variations and simply cannot get it to work.

The Parameter Name in SSAS is the same as the Parameter Name is SSRS.
The SSRS Server Details are correct in the SSAS Reporting Action as it opens the report successfully.
If I type in the job number itself as the Parameter Value, eg "170000007" then the Report runs successfully with the correct job no.

I can seem to find lots on passing parameters from a cube to an SSRS Report based ON a cube, but nothing about passing a parameter from a cube to an SSRS Report based ON a database as I think it makes a difference.

I am not good with MDX and have tried the following variations as the Parameter Value, some do return a value in the SSRS Report Job Parameter field (those with a YES) but the majority don't:

"170000007"      yes      works and the report runs successfully with the correct job no.

[Job Trades].[Job Trade].[Job No].&[170000007]      no      
[Job Trades].[Job Trade].[Job No].CurrentMember      no      
[Job Trades].[Job Trade].[Job No].CurrentMember.Name      no      
[Job Trades].[Job Trade].[Job No].CurrentMember.UniqueName      no      
[Job Trades].[Job Trade].[Job No].CurrentMember.Value      no      

…

Hi we have an SQL Server with a VLK.

We have some problem with the server and to start up the services.

I says in the log:
2017-04-25 10:01:05.92 Server SQL Server evaluation period has expired.
2017-04-25 10:01:05.92 Server SQL Server shutdown has been initiated

But that doesn't makes sense do to the fact that it is a volume license key we used.

is there anyway i can fix this?

I have a mobile report with one SSAS (MDX) dataset that has a parameter for the "Region". When I test the URL containing the parameter query string 2 of the 16 Regions don't populate any data on the mobile report. In SSMS and in data preview of the mobile report publisher ALL regions have data.

I've already checked the dataset for filters and I have none. Any ideas on what would cause certain MDX members not to pull up data?

Thank you!

Hi all,

I have a request from my client how to prevent any user accessing a cube from SQL Server Management studio. My problem is we are deploying and processing  a cube on dedicated server that we can not control all, it means  there are some local admin/ group admin accounts who are sys role privileges. They definitely view data from my cube database.

The question is here how I can prevent them viewing my data from cube although they are  local admin/ group admin accounts?

Thanks,

Hello Experts Exchange
I have followed the instructions of this question;
https://www.experts-exchange.com/questions/29002712/SSAS-Hierarchy-with-columns-with-folder-names.html

But when I browse the cube all my cost centres have the total amount that is in my data.

I have uploaded a screen shot to show what I mean.

How do I get the correct figures for the correct cost centre?

Regards

SQLSearcher
CostCentreFolders_Version2.xls
Cube-Cost-Centre.jpg

Hello Experts Exchange
I'm new to SSAS cube development.

I have data for cost centres that are going into my cube, please see file attached.

I want to create a SSAS Hierarchy with the data.

The column PARENTH1 is the Parent folder and HIER1 is the Child folder, there can be several levels of folders.

I want to use the PARENTH1 and  HIER1 to create the Hierarchy but I want to display the EVDESCRIPTION field to the user.

How do I do this in SQL Server Analysis Services?

Regards

SQLSearcher
CostCentreFolders.xls