Azure SQL Database
An Azure relational database service.
5,373 questions
13 answers
One of the answers was accepted by the question author.
Duration between min and max date
Hi Expert, I wanted to calculate max date for prodstatus =5 - min date for prodstatus=4 and max date for prodstatus =6 - min date for prodstatus=5 Create table CREATE TABLE [dbo].[testdata] ON [PRIMARY] GO Insert insert into …
asked 2022-05-19T12:08:58.697+00:00
Shambhu Rai
1,406
Reputation points
commented 2022-05-23T13:06:26.313+00:00
Shambhu Rai
1,406
Reputation points
12 answers
Best Performance: Data Centric Cube (very detailed) Tabular cube or Pivot reading a View
Good day, I have a data set of 2million records, however finance users setup OLAP Tabular via Excel with lots of attributes to see detail they don't filter down the view, they like seeing all Age records for current day vs history day snapshot or…
asked 2021-09-09T11:02:35.897+00:00
Ismail Cassiem
226
Reputation points
answered 2021-09-21T10:43:27.41+00:00
Ismail Cassiem
226
Reputation points
11 answers
Can adomd .net core connect to an SSAS endpoint from Linux?
Hi, I've a C# .Net Core 3.1 application, using the latest adomd .net core client, that successfully connects to an SSAS server and retrieves data when run on a Windows (Win10) platform. I've compiled it as portable, specific with libraries, and specific…
asked 2021-01-17T23:46:51.343+00:00
Richard Oakham
1
Reputation point
answered 2023-09-07T16:08:36.2866667+00:00
Руслан Черненко
0
Reputation points
11 answers
PowerPivot & MDS Architecture
Hi, I would to rollout PowerPivot to key users, im not too sure whats the best setup I am setting up 2 VM (Storage DB Engine, Analytics Presentation) How do i go about the architecture A. PPivot > On Storage VM create Views, affect ETL…
asked 2020-11-22T09:25:50.63+00:00
Ismail Cassiem
226
Reputation points
commented 2020-12-03T08:06:20.743+00:00
Lukas Yu -MSFT
5,821
Reputation points
10 answers
One of the answers was accepted by the question author.
How to schedule SQL Profiler traces for auto start and stop in a particular time
Hi ALL, In any way, Is it possible if we can schedule SQL profiler for future timing? That means, for example, can we schedule SQL profiler (NOW) to auto start/run the traces tomorrow at 5 AM -capture the traces - and then auto-stop tomorrow at 7:45…
asked 2020-09-20T15:06:04.42+00:00
Komal Sahu
311
Reputation points
answered 2022-11-02T08:57:33.47+00:00
aya asfour
1
Reputation point
9 answers
One of the answers was accepted by the question author.
Method not found: 'Microsoft.AnalysisService.Database Microsoft.AnalysisSerices.JsonSerializer.DeserializeDatabese
I am working on Visual Studio 19 Pro and have been unable to open any of my Tabular model projects. I have checked that extensions are installed have rolled back the versions and uninstalled/reinstalled and I continue to get the following: …
asked 2021-01-26T15:25:39.54+00:00
Ed Patino
36
Reputation points
commented 2022-03-26T13:42:49.373+00:00
Ferdi Bloem
1
Reputation point
9 answers
SSRS Breadcrumb not displaying
Hi, When I am adding number of report is master list and navigating to the report Breadcrumb is not changing in ssrs 2017 example: master list-report1,report2,repor3 when click on the report breadcrumb is not showing the report path.it only shots report…
asked 2020-10-21T18:14:49.563+00:00
Shri
21
Reputation points
commented 2020-10-29T06:41:52.937+00:00
Lukas Yu -MSFT
5,821
Reputation points
9 answers
MDX query from SSAS change type
Hi All, I have one MDX query and It takes the data directly from SSAS. The problem is that some of the measures are coming as string but not as a number like they are in the SSAS. I want to change the data type or something else. Now Im trying to use…
8 answers
One of the answers was accepted by the question author.
Really slow DISCOVER_CSDL_METADATA in SQL Server Profiler
Our setup is SQL Server 2019 Standard Edition + SSAS + multidimensional OLAP + PowerBI on top of it. Recent issue we noticed is that when user loads PowerBI report, from time to time forementioned event occurs. This leads to really long waiting time…
8 answers
Calculated measure in linked measure group is not refresh after cube writbeck
Hi All, I have two SSAS cubes: 1.Cube C1 with measure m1, writeback enabled partition 2.Cube C2 with measure m2 I have created cube C3 with two linked measure groups: C1 (measure m1) and C2 (measure m2). In cube C3, I have created calculated…
asked 2020-11-06T11:26:19.81+00:00
Dorota Papiernik
1
Reputation point
commented 2020-11-26T08:38:09.3+00:00
Lukas Yu -MSFT
5,821
Reputation points
8 answers
SSAS Other Presentation Tool
Hi, I have a sql enterprise 2014 with SSIS, SSAS, SSAS Tabular & Powerbi Powerbi is used more for gaphical view of cubes, with olap presnted in excel Mostly finance users so they love their excel but i have other business units who would like…
asked 2020-10-15T07:54:41.203+00:00
IC IC
236
Reputation points
answered 2020-10-19T03:34:03.317+00:00
Lukas Yu -MSFT
5,821
Reputation points
7 answers
case condition
Hi Expert, the below is the condition case when oid= 'Winter' then Name else 'noname' create table table1(id varchar(30), name varchar(30), oid varchar(30)) insert into table1 values('1', 'David', 'Winter') insert into table1 values('2', 'Hash',…
asked 2023-06-09T13:44:15.1866667+00:00
Shambhu Rai
1,406
Reputation points
commented 2023-06-20T09:03:32.7166667+00:00
Shambhu Rai
1,406
Reputation points
7 answers
Sum of different date by id
Hi Expert, I wanted to calculate max date for prodstatus =5 - min date for prodstatus=4 and max date for prodstatus =6 - min date for prodstatus=5 Create table CREATE TABLE [dbo].[testdata] ON [PRIMARY] GO Insert insert into…
asked 2022-08-12T20:07:00.45+00:00
Shambhu Rai
1,406
Reputation points
commented 2022-08-25T10:36:52.98+00:00
ShaktiSingh-MSFT
14,296
Reputation points Microsoft Employee
7 answers
One of the answers was accepted by the question author.
SQL Server 2019 Developer Edition Unable to Install
I had an old version of SQL Server on my laptop which I uninstalled. Now I am trying to install SQL Server 2019 Developer edition but I getting error: "Error Code(Decimal): 2068052293 Error Description: Please install the Visual C++2017…
asked 2020-09-28T02:08:25.643+00:00
Rakesh Kumar
21
Reputation points
answered 2022-04-18T11:17:18.513+00:00
Kirti Kumar
1
Reputation point
7 answers
Null values in dates - unable to read from ssis
Hi Expert, I am importing dates from excel to SSIS to load data but some values are null in dates so ssis unable to read it as date and reading as nchar SSIS reading as number or nchar have another date dimension where there is no…
asked 2022-03-30T19:40:42.047+00:00
Shambhu Rai
1,406
Reputation points
commented 2022-03-31T14:18:47.79+00:00
Michael Taylor
50,911
Reputation points
7 answers
One of the answers was accepted by the question author.
SSMS installation fails with ODB.MSI failure
My installation fails to look for the installation file 15.0.300.129.01 1031 sql_as_oledb.msi [297C:2DB4][2021-02-08T10:21:33]e000: BootstrapperEngineDataModel.OnError: Burn engine encountered error. PackageId: sql_as_oledb_x64, ErrorType:…
asked 2021-02-08T18:30:21.387+00:00
Perera, Priyantha
21
Reputation points
accepted 2021-02-22T16:07:32.613+00:00
Perera, Priyantha
21
Reputation points
6 answers
One of the answers was accepted by the question author.
remove values from string
Hi Expert, how will i remove all the characters from values in sql Create table test1 (id string, details string) insert into test1 values('20kjk','3ddf') Regards
asked 2022-08-17T10:50:23.187+00:00
Shambhu Rai
1,406
Reputation points
answered 2024-05-11T10:29:32.2366667+00:00
Ebrahim Bazarjani
5
Reputation points
6 answers
Import & DirectQuery mode issue on SSAS cubes
Dears, I'm facing this error when i need to convert default mode from import to direct query , anyone can help me , i can't reach to tmitransaction.inl file! Failed to save modifications to the server. Error returned: 'An unexpected error…
asked 2020-08-17T09:40:13.103+00:00
Osama Abu Asal
1
Reputation point
commented 2023-09-13T08:32:21.8733333+00:00
Antriksh Sharma
0
Reputation points
6 answers
Unable to install SQL Server(setup.exe). Exit Code(Decimal: 2061893606Error description. Wait on the Database Engine recovery handle failed
I already read an article about this , but I couldn't get that can anybody please explain how to resolve this issue???
asked 2022-11-11T13:12:03.687+00:00
sandeep garlapati
1
Reputation point
answered 2022-11-28T07:40:02.837+00:00
Seeya Xi-MSFT
16,461
Reputation points
6 answers
MS SSAS: Grand Total missing on one of my calculated members
Hi I am replicating an OLAP cube built in Java over in MS SSAS. I am a few weeks in and making progress, as I've not used SSAS before, and I just created some ne w calculated measures: (NotionalLONG) works: IIf([Measures].[Notional] > 0,…
asked 2022-07-08T12:57:44.35+00:00
Leigh Tilley
21
Reputation points
answered 2022-07-15T10:22:31.127+00:00
Leigh Tilley
21
Reputation points