thats just what I wanted!!!!

thankyou for that 🙂 Its becoming much clearer now.

Thanks for the info

Thankfully after sorting those issues out before this all of a sudden started working...

Now to the next error :crazy:

Im not having the best last 2 months

Deadline is the beginning on next week. :crying:

Thats sorted that issue out. Thankyou.

Deleting ad readding got rid of this. Im now left with errors

Errors in the OLAP storage engine: The attribute key cannot be found when processing:...

Ive deleted and added again in the Dimension useage tab. The red underline has gone. lets see what happens.

OK so...

Im in the cube. I go into the tab dimension useage

for the Age dimension the measure group column side is underlined in red

The Key column has data type Wchar...

It already is an integer. The data source is fine. Do you mean on the cube its self?

Looks like Ive got a lot more problems that that I currently have a very broken Project. T

Yes I have done all of that and the data source is reflecting the new data types

Thats the one...

Brilliant, thats sorted. Thankyou!

Mackers (12/6/2012)

---

Ahhh - this is in the cube structure screen (the main cube bit)

There should be a pane with measures & one with dimensions. Expand the dimension in the...

Mackers (12/6/2012)

---

Hi,

You can edit this in the dimension pane within the cube editor (the window that shows you what dims you have in you cube & allows you to add...

Hi again...

Im guessing no one has replied because this might be a silly question?

Im thinking it must be something to do with roleplaying dimensions....

http://msdn.microsoft.com/en-us/library/ms174487(v=sql.90).aspx

At least this might be...

I set it up as a string as its a varchar in SQL.

Annoyingly I go to paramters but it doesnt show any OR let me create them. I know they...