Yes, i knew about the option, and enabled it.

still m getting the same error.

i just want to create the set of measures (Normal as well as Calculated) and then create...

Hi Dirk,

Thanks for your update and suggession.

I tried using the givem function to create a calculated member, but still I am getting no value for the same.

Follwing is my query...

Wel these are my two queries where dimensions in the row axis are different rest is same

WITH

MEMBER [Measures].[v1] AS '( -1 * [Measures].[Value] )/1000'

SELECT

([Measures].[v1]) ON COLUMNS,

NONEMPTY([Product].[Prod_L03_Business_Unit_PNL_Items].MEMBERS)DIMENSION PROPERTIES MEMBER_CAPTION,...

Its a correlated sub query, and i have gone through may site which says corelated syb queries work very slow.

is tht true??

guide me

USE [COI_AppDB]

GO

/****** Object: Table [dbo].[COI_OSB_WINDOWS_FactData] Script Date: 12/10/2008 19:23:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[COI_OSB_WINDOWS_FactData](

[Scenario_MemberId_Label] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Time_Month_Label] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Allocation_MemberId_Label] [nvarchar](40) COLLATE...

Hi,

is there any other way to write the following query??

SELECT

'D_Account' AS SourceName

, 'Dimension' AS SourceType

, Fact.Account_MemberId_Label AS MissingLabel

, Fact.Datasource_MemberId_Label AS DataSource

, Fact.Scenario_MemberId_Label AS Scenario

, sum(Fact.[Value]) AS [Value]

FROM dbo.COI_OSB_WINDOWS_FactData Fact

WHERE...

yes..

EACH GROUPING HAS DIFFERENT COLUMN IN IT

Hi Arup,

wel can we do something instead of NOT EXIST

Thanks for the grouping trick

Hi Gail,

The inner query contains different tables

Hi Andras,

Thanks for your spontaneous reply, it was really kind of you.

I tried your query in sql 2005 it was woring fine over there.

Is it possible in...