Hello Again,

I found the solution and wanted to share it with the forum members.

Here is the solution:

declare @query varchar(MAX)

declare @Query2 varchar(MAX)

declare @Query3 varchar(MAX)

;With CTE as (select distinct CriteriaID from [dbo].[tblKPIResults])

select...

If you want to use this in SSRS then you should use ISNOTHING statement.

such as:

IIIF( ISNOTHING([saleunit].value)=true, 1,0)

You can also use the following code:

IIF ( saleunit.value IS NOTHING,1,0)

I hope it helps

Thank you for your reply.

In my MDX you can see a snippet such as:

[p]

SELECT NON EMPTY { [Measures].[Sale Unit],[Measures].[DC Stock Level],[Measures].[Store Stock Level] } ON COLUMNS

[/p]

This code part returns all...

I have tried to apply following on textbox:

Select -- > Sale_Unit -- > Properties --> Visibility --> Hidden Expressions:

iif(IsNothing(Fields!Sale_Unit.Value),True,False)

and report still shows the NULL Sale Unit rows

There are three measures in this report. And I think it is something about NONEMPTY keyword.

Any idea?

Thank you very much for your great comment.

Is it really such a complex query issue to get running totals of a table?

Regards

could you please give me a sample?

Thank you very much for your comments.

But, I think in this case I cannot filter my fact table. So, how can show a specific week's inventory values ( I mean...

The problem is SSAS returns the Equal operator for the datefilter. But it should be <= operator for this date filter.

I can get the correct result by using <= operator.

Is...

Year --> Month --> WeekOfYear -->DateID

33 is the 33th week of the year.

Thank you for your replies. I have modified my code as follow:

Select CAST((b.Week ) as int)as WeekOfYear,CAST(a.dateID as int) as DateID, CAST( b.year as CHAR(4)) as Year , a.StyleCode, cast(a.WarehouseID...

Thank you very much for your great comments. Problem solved with your helps!

I have used DateID column with int datatype. Because my purpose is to use this column as a...

Thanks for your reply.

Actually, I want to retrieve the MAX(InvDate), Quantity combination of each item. But as you considered, this combination should be in weekly basis.

If you select LookupInv table...

Thank you again. I have solved the problem. Your vision has opened the door!

I have added a member to my MDX query. I think it will be very useful for...

Thank you for your reply.

Sorry,I am a little bit confused.

Where do I put this code?