create table #t1 (ITem_no int)

insert into #t1 (Item_no) values (1)

insert into #t1 (Item_no) values (2)

insert into #t1 (Item_no) values (3)

create table #t2 (ITem_no int, format varchar(16))

insert into #t2 (Item_no, format)...

To give a database role permission to process a cube

1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object...

You can use OPENROWSET or OPENQUERY to retrieve data from a cube into your relational database. Check http://support.microsoft.com/kb/218592 for some examples.

I think a query like the one below also returns the desired result. Although I'm not sure if this is the most efficient way to do it.

with

set...

THat's because Q1 2007 and Q1 2008 have the same key on the Quarter level. You should add the column holding the year value from your time table to the...

Greg Galloway has written an excellent blog on this subject: Self-Documenting Cubes in Excel PivotTables

Hi,

you could either created a calculated measure (as you requested)

with

set Sam as {

[Customer].[Customer Code].[Sam1],

[Customer].[Customer Code].[Sam2],

...

then you should put another hierarchy on the rows axis. I just put the filteredset on that axis as an example

yeah, but how can those reports be trusted?! you don't want...

Is your [Dim Costumer] dimension connected to a measure group containing Sales? Then you can use the following statement assuming your measure name is called Sales:

WITH

SET FilteredSet AS

...

sorry, it should have been

WITH

SET FilteredSet AS

[Dim Costumer].[Cod].ALLMEMBERS *

[Dim Costumer].[Age Group].&[0-14] *

[Dim Store].[Cod].&[51] *

[Dim Date].[D].&[2010-07-21]

MEMBER [Measures].[x] AS Count(FilteredSet)

SELECT {[Measures].[x]}...

try the query below it should perform better the using the filter function

WITH

SET FilteredSet AS count (

[Dim Costumer].[Cod].ALLMEMBERS *

[Dim Costumer].[Age Group].&[0-14] *

[Dim Store].[Cod].&[51]...

I can see where you're coming from and if you put it this way it makes sense to develop a BI solution by that procedure. However I still think that...

Are you looking for something like this?

WITH

SET FilteredSet AS filter (

[Dim Costumer].[Cod].ALLMEMBERS,

[Dim Costumer].[Cod].CurrentMember.Properties("Age Group") = ... and

[Dim Costumer].[Cod].CurrentMember.Properties("Cod") = ... and

[Dim...

I...