I\'m backing up an SSAS database using the code below, but keep getting this error:Incorrect syntax near \'<\'. [SQLSTATE 42000] 开发者_如何学JAVA(Error 102).The step failed.
There is probably a simple answer to this question but I do not have much experience with SQL Server/SSAS. I can connect to my local server PCNAME\\SQLEXPRESS in SQL Server 2008. On that server I have
I am getting trouble to use Build solution in Visual Studio. I was building data cube and I needed to use Build solution to finalizemy project.
I\'ve been seraching for the data type of LONG CONTINUOUS in SQL Server Analysis Services 2008 R2. Can anyone point me to the documentation?
I have a cube with a measure of type 开发者_如何学Godate, performing a max aggregation, where some of the data points have a null value for date. In these cases, the Max value becomes 12/30/1899 which
I\'m trying to permanently create a ca开发者_高级运维lculated dimension member using a MDX ADOMD command from C# code.
I have a timespan in a datawarehouse representi开发者_开发知识库ng time spent by a user doing a task (not a time dimension, but a measure). In SQL I have this set as datetime. When this is pulled into
I have a cube that shows order volume history, but showing the month to date numbers isn\'t that useful (since they\'re way out of whack with other full months). I want to include that data in some ki
I just started working with SSRS, and figured out how to connect my MDX Query to a Cube and plug that into a Matrix
In my Date Dimension I have 2 hierarchies: [Year - Week - Date] and [Year - Month - Date] I want to check in a Cube Calculation if the current level of the Date Dimension is [Date] (the lowest level