No announcements
Found 1126024 threads
-
0 VotesSSRS combining MDX and T-SQL +
SSRS allows you to select data from different sources, for example sql server and ssas.Answered | 4 Replies | 8864 Views | Created by volyn - Wednesday, November 9, 2011 10:12 AM | Last reply by volyn - Saturday, November 12, 2011 12:41 PM
-
1 Votes
SQL to MDX for SSRS
Hi Hiren, In MDX, the where clause is applying a slicer on the cube.Answered | 4 Replies | 942 Views | Created by contacthirenparikh - Wednesday, May 11, 2016 12:10 PM | Last reply by contacthirenparikh - Thursday, May 12, 2016 2:59 PM -
0 Votes
Parameter to mdx in ssrs
http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/8259343a-85de-4aaa-ba13-59d73cdfb1c6 http://social.msdn.microsoft.com/Forums/en-US/sqlanal ...Answered | 2 Replies | 2046 Views | Created by RickyDaCoder - Monday, November 12, 2012 6:28 AM | Last reply by Fanny Liu - Tuesday, November 13, 2012 10:04 AM -
1 Votes
Comparing MDX and T-SQL query run time
For my demonstration I create a fact table with some 100 million rows, the t-sql queries were in minute range and mdx queries in seconds.Answered | 2 Replies | 3641 Views | Created by Anonymouse_H - Saturday, June 26, 2010 11:45 PM | Last reply by Anonymouse_H - Sunday, June 27, 2010 11:05 AM -
2 Votes
MDX problem in SSRS
That little piece of code has greatly enhanced my understanding of MDX.Answered | 6 Replies | 4269 Views | Created by Don_Quixote - Thursday, September 29, 2011 5:51 PM | Last reply by Don_Quixote - Tuesday, October 4, 2011 11:39 AM -
1 Votes
MDX in SSRS, Mutiple custom measures
Are you using NON EMPTY to filter out empty cells in your MDX?Answered | 3 Replies | 5858 Views | Created by Randall_M - Friday, February 22, 2013 6:04 PM | Last reply by Josh Ashwood - Tuesday, February 26, 2013 3:21 AM -
0 Votes
MDX vs SQL
If you are doing more traditional or opertational reporting, T-SQL out of a relational database structure will generally suffice.Answered | 1 Replies | 4745 Views | Created by Javier Guillen - Monday, December 7, 2009 4:05 PM | Last reply by BI Baracus - Monday, December 7, 2009 6:59 PM -
1 Votes
ssas mdx and t-sql gives different values
In the first post, it appears you are comparing the MDX results to a T-SQL query running against the source table, yet you say that the measures and ...Answered | 7 Replies | 2071 Views | Created by Noname_13 - Thursday, March 7, 2013 9:49 AM | Last reply by Bharath_RAM - Thursday, April 4, 2013 5:55 AM -
1 Votes
MDX in SSRS
There, you can enter your MDX statement.Answered | 4 Replies | 8970 Views | Created by Jordie Williams - Thursday, October 30, 2008 2:56 PM | Last reply by Jordie Williams - Thursday, October 30, 2008 5:01 PM -
0 Votes
SSRS multi value parameter used in SSAS MDX
I am trying to pass sql paramter value to MDX. the cube has similar value as that of parameter value.Answered | 9 Replies | 4208 Views | Created by Scottichrosa - Friday, January 12, 2018 10:07 AM | Last reply by Zoe Zhi - Friday, January 19, 2018 5:39 AM -
1 Votes
create table of combinations in T-SQL
By the way, the Transact-SQL control-of-flow language keywords are listed here.Answered | 4 Replies | 877 Views | Created by EPG48 - Friday, May 13, 2016 5:20 PM | Last reply by Sam Zha - Monday, May 16, 2016 5:52 AM -
0 Votes
ssas vs t-sql
The same can be done in T-SQL.Answered | 8 Replies | 1538 Views | Created by arkiboys - Wednesday, April 20, 2016 2:00 PM | Last reply by Munna Kollu - Friday, April 22, 2016 5:19 PM -
2 Votes
MDX query with SSRS report duplicates
As query in SSRS can only support two axes,do not support multidimentional like multidimentional cube.Answered | 7 Replies | 1154 Views | Created by StSingh - Thursday, August 31, 2017 5:00 PM | Last reply by StSingh - Friday, September 1, 2017 5:49 PM -
0 Votes
MDX queries to SQL
Hi, we can covert mdx to sql using linked server ..Answered | 2 Replies | 1237 Views | Created by Bharath_RAM - Monday, August 31, 2015 5:01 AM | Last reply by Priya.N - Tuesday, September 22, 2015 10:04 AM -
0 Votes
Combine 2 mdx queries
Actually i am stuck up again while joining 2 mdx queries with same hierarchy.Answered | 5 Replies | 1076 Views | Created by harshita1612 - Thursday, March 8, 2018 5:51 AM | Last reply by willson yuan - Friday, March 9, 2018 1:55 AM -
0 Votes
how to convert MDX query to SQL
Hi Vishu, As Olaf said, this is a calculated member which used in MDX script in your cube, we cannot execute it in SQL Server Management Studio directly.Answered | 6 Replies | 1686 Views | Created by vishu_k - Tuesday, July 8, 2014 4:03 PM | Last reply by Charlie Liao - Wednesday, July 9, 2014 6:46 AM -
0 Votes
SSRS MDX : Dimension Attribute selection dynamically.
SSRS created two datasets for mdx parameter like CategoryDataSet for Category and StyleDataSet for Style.Answered | 4 Replies | 5609 Views | Created by PA Kumar - Monday, July 1, 2013 12:10 PM | Last reply by PA Kumar - Friday, July 5, 2013 1:47 PM -
0 Votes
Emailing an SSRS report from T-SQL or C#
Hi Raja, Assuming you are using Enterprise edition, this is exactly what the SSRS data-driven subscription feature is designed to do and it doesn't require coding.Answered | 1 Replies | 4175 Views | Created by RRaman - Thursday, September 24, 2009 10:24 PM | Last reply by Teo Lachev - Friday, September 25, 2009 1:42 AM -
0 Votes
T-sql ssrs help
Choose a multiple value parameter set up and use the IN syntax in your query from the SSRS: WHERE yourcolumn in (@theparameter)Answered | 6 Replies | 763 Views | Created by MarkSubedi - Monday, May 9, 2016 10:32 PM | Last reply by Jingyang Li - Tuesday, May 10, 2016 6:37 PM -
0 Votes
Error MDX on SSRS- Dataset with condition
In this scenario, please try to use MDX functionAnswered | 7 Replies | 1159 Views | Created by Yudhi.Hermawan - Friday, April 13, 2018 8:59 AM | Last reply by Ousama EL HOR - Wednesday, April 18, 2018 8:25 AM - Items 1 to 20 of 1126024 Next ›
No announcements
