Viewing 15 posts - 1 through 15 (of 42 total)
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
December 15, 2010 at 5:25 pm
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
December 15, 2010 at 2:48 pm
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
December 15, 2010 at 2:45 pm
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
December 14, 2010 at 3:12 pm
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). ...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
December 3, 2010 at 3:24 pm
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
December 1, 2010 at 12:35 pm
Alvin Ramard (11/5/2010)
Does dislocating my shoulder at least 13 times count?Surgery twice didn't completely fix the problem. 🙁
I've always wondered if by dislocating your shoulder you'd be able...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
November 11, 2010 at 3:50 pm
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
November 11, 2010 at 3:17 pm
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,...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
October 30, 2010 at 7:48 am
Michael Valentine Jones (10/29/2010)
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
October 30, 2010 at 7:43 am
PaulB-TheOneAndOnly (10/29/2010)
RainbowFfolly (10/29/2010)
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
October 29, 2010 at 3:47 pm
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
October 29, 2010 at 9:48 am
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
June 28, 2010 at 4:34 am
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...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
June 25, 2010 at 5:34 pm
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. ...
_____________________________________________________________
MAXIM 106:
"To know things well, we must know the details; and as they are almost infinite, our knowledge is always superficial and imperfect."
Francois De La Rochefoucauld (1613-1680)
March 24, 2010 at 6:31 pm
Viewing 15 posts - 1 through 15 (of 42 total)