Description:
Microsoft SQL Server newsgroup.
|
|
|
Sorting needed in MDX with Topcount and NON Empty Filter
|
| |
Hi, Can any one help me with sorting the data year wise for below MDX without much changing the MDX means that data should be displayed yearwise.....that is first for 2002, then 2003, then 2004..in this order... SELECT NON EMPTY {TopCount({Crossjoin({[Measure s].[Reseller Sales Amount]},{[Geography].[Geograp hy].[(All)].AllMembers})},20,[ Measures].... more »
|
|
|
The attribute key cannot be found when processing dimension
|
| |
Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer... more »
|
|
|
The attribute key cannot be found when processing a dimension
|
| |
Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term nvarchar(1024) Here referer_id is the key column and referer is the name column. referring_term is an attribute. referring_term is a substring extracted from referer... more »
|
|
|
Sql Svr 2005 start new Olap proj - not same as sql svr 2000?
|
| |
With sql server 2000 Personal edition I was able to load the Olap server on my workstation on practice some mdx queries on a cube with the sample app that ships with personal edition. Now I have sql server 2005 developer edition and I selected analysis services on the install, but the analysis servervices tab doesn't bring up a project window - it just brings up a... more »
|
|
|
Event 3238002710 Error
|
| |
I am seeing an error in my Application log at various times with the following: Log Windows NT (Application) Source MSSQLServerOLAPService Category (256) Event 3238002710 Computer XXXXXXX Message The description for Event ID '-1056964586' in Source 'MSSQLServerOLAPService' cannot be found. The local computer may not have... more »
|
|
|
OR Operator in MDX
|
| |
Hi, I have a question based on the need to use OR operator in a MDX query. How can I filter a query using something like this conceptual code? [Customer].[City]=[Customer].[ City].&[Austell]&[GA] OR [Geography].[City]=[Geography] .[City].&[Austin]&[TX] From adventure works DW? Thanks! Chenn.
|
|
|
Replacing a local cube file in a PivotTable
|
| |
I have created a PivotTable that queries a local cube file. This .cub file (Analysis Services 2008) is updated every week The structure remains the same.But when I replace the old .cub file with the new one the refresh fails. Any idea on how to update the pivottable data with the new file's figures?... more »
|
|
|
Roles, hide dimension question
|
| |
Does this Connect case describe what you want to do - in that case, you can deny access to members and omit the dimension in a perspective (assuming you have Enterprise Edition): [link] ackID=233410 ...Denying Access to a Whole Dimension by Christopher Webb Active... more »
|
|
|
Locking while processing a dimension in SSAS2008
|
| |
Recently we upgraded to SSAS2008 from SSAS2005, and since that upgrade we've been experiencing locked files while running a Process Update on a dimension with Process Affected Objects selected. This doesn't happen when the Process Affected Objects option is NOT selected. It'll happen several times a day.... more »
|
|
|
|
