Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicklarge
Starting Member
40 Posts |
 Posted - 2011-10-25 : 12:27:00
|
Hello.I am using MDX in SQL 2008 with SSRS 2008. In order to use MDX with the SSRS parameters, I need to create the MDX as an expression which is tedious because I need to keep putting in (space)"(space)+ at the end of every line, as well as other nuances. This is not an efficient way of doing this and is thoroughly annoying.  If I create a report with SSRS using SQL, then I can refer to a stored procedure or view, and be more efficient by reducing the amount of text in my SSRS Dataset, moving it instead to the SQL database.Please can someone tell me if there is a more efficient (and effective) way of doing this? Is there the equivalent of a SQL view in SSAS, or am I stuck with this method for good?Thanks in advance, Nick.  |
|
|
|
|
|
MDX views?