Viewing 15 posts - 1 through 15 (of 613 total)
April 17, 2024 at 6:36 pm
Why SSRS? Do you need user interaction?
If you don't need user interaction then there are better ways to do this. SSRS is for creating formatted output so I am not...
April 5, 2024 at 6:16 pm
This sounds like more of an asp.net application issue rather than a SQL issue. I would not store links in the database. When you the user clicks the initial page...
April 1, 2024 at 7:23 pm
This is tsql
DROP TABLE IF EXISTS #Roles;
SELECT * INTO #Roles FROM OPENROWSET
(
'MSOLAP',
'Data Source=localhost;Initial Catalog=YourSSASDatabaseName;Provider=MSOLAP.4;Integrated Security=SSPI;Format=Tabular;',
'SELECT * FROM $System.TMSCHEMA_ROLES'
);
DROP TABLE IF EXISTS #RoleMemberships;
SELECT * INTO #RoleMemberships FROM OPENROWSET
(
'MSOLAP',
'Data Source=localhost;Initial Catalog=YourSSASDatabaseName;Provider=MSOLAP.4;Integrated Security=SSPI;Format=Tabular;',
'SELECT...
March 26, 2024 at 7:56 pm
You can issue an MDX query or a TSQL query against a linked server.
https://www.sqlshack.com/linking-relational-databases-with-olap-cube/
March 26, 2024 at 2:50 pm
This?
SELECT * FROM $System.TMSCHEMA_ROLES
SELECT * FROM #TMSCHEMA_ROLE_MEMBERSHIPS
March 22, 2024 at 5:17 pm
Are there any performance considerations or other pros/cons in using EXEC at Linked server vs. OPENQUERY?
Example: EXEC MyLinkedServer.MyDatabase.dbo.sp_executesql @SQL
March 18, 2024 at 6:26 pm
Good point. I have a composite primary key comprised of 3 INT columns.
Maybe.
CASE WHEN SampleType = 1 THEN 0 ELSE PK1 + PK2 + PK3 END
Although I guess the 3...
March 13, 2024 at 3:16 pm
Thanks for all the solutions. I'll adapt to my actual DDL and report back If I uncover anything notable.
March 13, 2024 at 2:41 pm
This seems to work but I somehow doubt it will perform any better.
SELECT
DISTINCT
Color,SampleType,
SUM(SampleValue)OVER(PARTITION BY CASE WHEN SampleType = 1 THEN Color ELSE CONVERT(VARCHAR(MAX),RowNum) END) AS SampleValue
FROM
(
SELECT ...
March 12, 2024 at 11:27 pm
Try
SUM(IIF(SampleType = 1, SampleValue,0))
Like this?
SELECT Color,SampleType,
SUM(IIF(SampleType = 1, SampleValue,0))
FROM #SampleData
GROUP BY
Color,SampleType
March 12, 2024 at 11:22 pm
It looks like RefreshedTime FROM $System.TMSCHEMA_PARTITIONS will not update when there is a processing error.
So by snapshotting RefreshedTime pre-processing and comparing to RefreshedTime post-processing you should see objects that did...
March 11, 2024 at 6:57 pm
I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.
February 27, 2024 at 4:58 pm
thanks, does anybody have access to enterprise? The reason i ask is that there was a time when you had to use a backdoor thru multidimensional to achieve this...
February 21, 2024 at 6:53 pm
Thanks for the links Jeff. I am going to put PIVOT in the 'do not use' receptacle where it can hang out with MERGE. 🙂
January 31, 2024 at 12:00 am
Viewing 15 posts - 1 through 15 (of 613 total)