Hello everyone,

Really appreciate any help. Is the steps that I wrote not clear enough or somehow confusing? please advice what else I could explain to make it more clear.

Many thanks...

Hi all,

Thanks for your kind advice.

I followed the conclusion to add in Fact table then, however I probably doing it the wrong way.

Here is what I did :...

Hi,

I confirmed my column 'date invoice' is a Date. I checked to my V.Studio SSAS project file, and in the DSV of my Fact Table, DataType is System.DateTime

Now at my...

Hi all,

Just to add, the SSRS is for Analysis Server (SSAS Cube) and the "date invoice" information is Text datatype (I think so). Could it be the problem ?

But I...

Thanks for the input.

As mentioned, I'm using Wizard, but today I get rid of it, create my own table like you are saying, and it works.

I can change the...

Hi,

Is the problem because I create this dimension by Wizard and choose "Create Time table from server" ?

I also notice, NameColumn property is "New binding(WChar)

If I click the ellipsis, Binding...

Hi,

we have tried this, but it won't worked. When we browse again, it still show the full date format with minutes to second.

Thanks.

Hi Brian,

Thanks.

My cube is Multidimensional. I did specify it in Format string.

The date is created from the standard date dimension and in Date dimension attribute (which is the key), I...

How about TFS ? Team Foundation Server....