ssas

相关标签：javascript jquery android 多少钱 iPhone

SSAS backup script fails in job, but works in query window

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.[详细]

2023-03-23 03:29 分类：问答
Connection failing when I try to process a cube in BIDS

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[详细]

2023-03-22 23:39 分类：问答
Can't select "Build Solution"

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.[详细]

2023-03-22 11:15 分类：问答
SQL Server Analysis Service 2008 R2 LONG CONTINUOUS Data Type

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?[详细]

2023-03-22 04:38 分类：问答
SSAS Date Measure Max StringFormat when Null

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[详细]

2023-03-21 21:54 分类：问答
SSAS: programmatically & permanently create calculated member

I\'m trying to permanently create a ca开发者_高级运维lculated dimension member using a MDX ADOMD command from C# code.[详细]

2023-03-21 15:36 分类：问答
SSAS TimeSpan in Aggregation

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[详细]

2023-03-20 15:11 分类：问答
Show data over rolling months instead of calendar months in SSAS

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[详细]

2023-03-19 13:07 分类：问答
SSRS: adding a Matrix based on 2 DataSets

I just started working with SSRS, and figured out how to connect my MDX Query to a Cube and plug that into a Matrix[详细]

2023-03-18 17:48 分类：问答
Check if level in any dimension hierarchy is [Foo]

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[详细]

2023-03-17 13:43 分类：问答