I think I've cracked it!

So for the benefit of anyone who ever suffers the same problem as I did...

The easy way to do it is to set the Language...

Sorry, but I forgot to mention earlier that when browsing the cube in SSAS it does display the correct currency (i.e. £). That seems to point to Excel being...

Hi GSquared,

I was under the impression (maybe misguided!) that they would be inherited from SSAS. When I highlight and format the cells in the pivot table to currency, they...

As the others have said, they can really help with organisation and maintainability. I find them a real asset in holding a group of related tasks together that would...

Hi Ganesh,

I had to do something similar a few months ago (i.e. writing to MS Excel files that I needed to copy to our network with dated file names). ...

As much as I like Osama's choice, Pablo's recommendation is definitely the most sensible (and pretty clear for the end-users too), so after hours spent considering the pros and cons...

I've always wondered if by dislocating your shoulder you'd be able...

Thanks guys!

I've got to admit that it's normally internal action within the company that affects my design considerations, but knowing that the Universe itself could end up conspiring against me...

Correct design decisions aside, I'm sorely tempted to include these events in the date dimension for the time being. The reason for this is that by storing this data,...

Michael Valentine Jones (10/29/2010)

---

Events may have more dimension attributes than just time and they might have multiple date ranges involved. For example, a book signing might be in store...

PaulB-TheOneAndOnly (10/29/2010)

---

RainbowFfolly (10/29/2010)

---

No I hadn't even thought of it. I think I may have been unwittingly brainwashed by Kimball into believing that if Ralph hates snowflakes then so should...

Hi Pablo,

No I hadn't even thought of it. I think I may have been unwittingly brainwashed by Kimball into believing that if Ralph hates snowflakes then so should I...

Hi,

Thanks for all the replies. There's a lot to keep me entertained and I'm enjoying working my way through Gail's blog.

I really like Wayne's wildcard solution for it's...

Hi bteraberry,

Firstly, thanks so much for the prompt reply. 🙂

Secondly, I love the fact that you expanded on the example I gave. with a lookup table to handle the possibilty...

Hi Westy,

If you're going to use a disconnected recordsets with your forms then any relevant linked tables seem redundant to me as you'll be populating the forms via code. ...