Thanks for your response Sowbhari and Alan. It really helped me alot 🙂

Hi Paul Thanks For the reply,

If you can provide some more information on this, It will help me to understand better.

1. will degenerate dimension contain only one attribute ?

as...

Thanks for your time and explanation.

Here I want to share my issue,

Day1: 09.01.2013 (dd.mm.yyyy)

Day2: 08.01.2013 (dd.mm.yyyy)

Datediff column has to show the difference...

Hi, I need to convert a multi valued parameter string value into int/number. example:

parameter value is [Land DIM].[Land].&[567], [568],[569]....

but out of this value i just need to pass 567, 568,...

please share your ideas , upon above expression result.

3 parameters 'PONDS', '897','EN' should be like this.

here 897 is store key for [Store DIM].[Store].[897] dimension member.

Hi , please share your ideas about above expression result..

???

Thanks Koen for your explanation,

yes, I checked thoroughly according to your explanation.

1. Mappings are absolutely fine

2. It is not perspective, I browsed direct cube only.

3. I can see all the...

HI Jayanth, thanks for your reply.

can you please elaborate on these 3, what need to be checked or what can be changed.

Dimension mapping

Perspective

Permissions on the measure group.

Thanks again,

Niha

Thanks Sam for your reply, relations are in place.

problem is for only one product it is not showing data.

br,

Niha

Hi All,

currently in my solution one cube structure has changed.

according to the new cube we are modifying the existing reports.

here my problem is

I prepared a dataset with new cube members

SELECT...

Thanks for the reply ,

problem has moved a bit forward , But strucked over a little change

=iif(Cint(ReportItems!Sales38.Value)>99999,ReportItems!Sales38.Value,FormatNumber(CDbl(ReportItems!Sales38.Value),"N2"))

this is the expression i have written. with help of this am getting...

Hi Thanks for ur reply,

if u can explain in detail about previous query , it will help me alot.

show me the right way of thinking.

am not an expert in sql...

Thanks for the reply

and if there are many date keys we can choose appropriate one to make partitions.

but for following query , how can we choose

SELECT ...

Hi All, for below query what could be the considerable date for partitioning basing on month.

here we can see translation date, document date, posting date dimensions.

which one should consider?

SELECT...