Hi Tom, thanks for your answer.

Please forget my first post, I copied and pasted the query that SSAS issues, therefore contains this weird aliasing.

Here is a better code:

SELECT

...

I have no luck today :w00t:

here the results of your query:

Other interesting results:

Thanks for your time!

Hi Cadavre,

your script is the best explanation I have ever seen for the ASCII characters an trimming functions. But that is exactly my problem, that the last position with ASCII...

Hi,

here a snap-shot from management studio:

Thanks for the quick answer!

Hi Martin,

thanks for your answer.

The goal is not save time in development, actually the cube and calculations become more complex.

The question behind is what is most intuitive for the cube...

Hi Martin,

thanks so much for your useful answer. I just want to give you an example to see if I have understood correctly:

Use Scenario:

I decide to have a...

Hi Andy,

thanks so much for the article and your priceless time.

I was thinking in a solution for a new challenge I got yesterday when I received the SQL Server Central...

Hi Friends,

it was really really strange, but I had to reload the data mart database and then my data is back.

It seems something like SSAS was not able to recognized...

Hi,

please find below my comments:

yayomayn (8/7/2014)

---

In Visual Studio which version of the data are your project data sources looking at?

I have 2 environments, one dev server and one test...

Hi Koen,

thanks for your quick answer.

I am not applying any filters in the dsv (actually I don’t know how to do that), in fact I manipulate the data only...

Greetings to my namesake!

The links are enough help, so please do not say sorry.

The first one was not exactly my case, I implemented a many-to-one and not a one-to-many currency...

Hi yayomayn,

thanks again for your useful tips.

I just want to extend this discussion.

I wrote some MDX code like this in order to get the value in a reference currency across...

Hi yayomayn,

thanks so much for your useful answer.

Both references were very hepful. At the end I implemented something like this and it works correctly:

CREATE MEMBER CURRENTCUBE.[Measures].[Gross Sales Euro] AS [Measures].[Gross...

Hi kdaniapam,

I would like to help you but you should be more specific and give us more details.

What is not working and why?

Of course it is a best practice, I...

Hi Wesley,

could you try to change the data type in the Flat File Source to DT_WSTR (nvarchar).

I know it is only a workaround and does not explain why your package...