🙂 Thank you so much for your reply, get back to you on this.

Hi,

I'm confused... because FID is passing the correct value I.e July 2012 in both the measures but while displaying this via [Measures].[First Invoice Date2] shows correct result (I.e. July 2012)...

Hi,

Did you get chance to find the issue with First Invoice Date measure please?

Regards,

Amit J

Hello

Please ignore above code, it is consfusing with this please get a look on following code

WITH

SET WTDCP

--AS StrToMember(@Week)

AS StrToMember("[Time].[Fiscal Hierarchy].&[2013043]")

--YTD

MEMBER [Measures].[First Month of Year]

AS ANCESTOR(WTDCP.item(0), [Fiscal Hierarchy].[FiscalMonth]).PROPERTIES("key", TYPED)...

WITH

SET WTDCP

--AS StrToMember(@Week)

AS StrToMember("[Time].[Fiscal Hierarchy].&[2013043]")

--YTD

MEMBER [Measures].[First Month of Year]

AS ANCESTOR(WTDCP.item(0), [Fiscal Hierarchy].[FiscalMonth]).PROPERTIES("key", TYPED) = ANCESTOR(WTDCP.item(0), [Fiscal Hierarchy].[FiscalYear]).FIRSTCHILD.FIRSTCHILD.FIRSTCHILD.PROPERTIES("key", TYPED)

SET YTDCP

AS IIF([Measures].[First Month of Year], NULL, PERIODSTODATE([Time].[Fiscal Hierarchy].[FiscalYear], Ancestor(WTDCP.item(0),[Time].[Fiscal Hierarchy].[FiscalMonth]).PREVMEMBER))

SET YTDPP

AS...

Hello

I'm sorry don't know how to past query under code block, is this someting under under IFCode (XML code)? ?

WITH

SET WTDCP

--AS StrToMember(@Week)

AS StrToMember("[Time].[Fiscal Hierarchy].&[2013043]")

--YTD

MEMBER [Measures].[First Month of Year]

AS ANCESTOR(WTDCP.item(0), [Fiscal Hierarchy].[FiscalMonth]).PROPERTIES("key", TYPED) = ANCESTOR(WTDCP.item(0), [Fiscal Hierarchy].[FiscalYear]).FIRSTCHILD.FIRSTCHILD.FIRSTCHILD.PROPERTIES("key", TYPED)

SET YTDCP

AS IIF([Measures].[First Month of Year], NULL, PERIODSTODATE([Time].[Fiscal Hierarchy].[FiscalYear], Ancestor(WTDCP.item(0),[Time].[Fiscal Hierarchy].[FiscalMonth]).PREVMEMBER))

SET YTDPP

AS...

Hi,

We are using following code for measure:

MEMBER [Measures].[FID] AS

Head(

NonEmpty(

EXISTING [Time].[Fiscal Hierarchy].[FiscalMonth].Members,

([Measures].[Sales Quantity])

),

1

).Item(0).properties("key", TYPED)

MEMBER [Measures].[First Invoice...

Thank you so much sir for response.

This is parameterized query to use in SSRS.

Also as suggested, we are trying make the cross join with Brand in Set but we are...

amit_pjoshi (7/10/2013)

---

Hi Gail,

No we are not using BEGIN TRANSACTION / COMMIT TRANSACTION.

we are executing the same code...

Hi Gail,

No we are not using BEGIN TRANSACTION / COMMIT TRANSACTION.

we are executing the same code shared...

ChrisM@Work (7/10/2013)

---

amit_pjoshi (7/10/2013)

---

Lowell (7/10/2013)

---

instead of

EXEC sp_executesql @sql

use

EXEC(@sql)

which has no limits on the query size, since it's not parameterized. ou are not passing parameters via sp+executesql,...

ChrisM@Work (7/10/2013)

---

amit_pjoshi (7/10/2013)

---

Lowell (7/10/2013)

---

instead of

EXEC sp_executesql @sql

use

EXEC(@sql)

which has no limits on the query size, since it's not parameterized. ou are not passing parameters via sp+executesql,...

Lowell (7/10/2013)

---

instead of

EXEC sp_executesql @sql

use

EXEC(@sql)

which has no limits on the query size, since it's not parameterized. ou are not passing parameters via sp+executesql, so you'd...

Lowell (7/9/2013)

---

amit_pjoshi (7/9/2013)

---

Hello Expert,

Can someone help its very urgent?

While developing the SSRS report we have to create a stored procedure using MDX query for this we have to hold the...