Viewing 15 posts - 1 through 15 (of 18 total)
Steve,
Thanks for you help on the 28th. But the boss says I can't change the cubes, and I don't know how to change the MDX the pivot table uses....
May 4, 2005 at 7:46 am
Interesting ideas, thanks. I'll investigate.
Jennifer
April 29, 2005 at 11:32 am
Hey stevefromOZ,
Thanks for the info. In another incarnation that may be the answer. But for now, I can't change the environment. Got any ideas on that basis?
April 28, 2005 at 8:34 am
Mark,
How about reprocessing the cube?
Do you not want to do this for some reason?
Jennifer
April 10, 2003 at 2:09 pm
Hello saama5,
This should return the lowest key that does not have a consecutive key:
SELECT MIN(keyName)
FROM tableName
where keyName <plus sign> 1 NOT IN
(SELECT keyName FROM tableName)
(In the third line between...
March 23, 2003 at 10:29 am
I'll check out the news group info. Thanks.
How about making another shared dimension with just state & city. When I do this, keeping the duplications in both levels, it works...
March 23, 2003 at 10:07 am
Hi stevefromOZ - hope you are well.
I assume at one time you had one cube and used the BusinessUnit level to provide a way to divide your data. But now...
March 20, 2003 at 1:50 pm
Cubes in Analysis Services have a very tight relationship with their source database.
Suppose you archive the cube (you really archive the whole database that the cube lives in) into...
March 18, 2003 at 9:37 pm
Hello Sundar,
How about this:
Select * from tableName
Union All
Select Top 1 * from tableName
Jennifer
March 17, 2003 at 1:50 pm
Steve,
I've got about 500 facts in my fact table and I want each as a sum measure in the measures dimension. So that means about 500 sum measures.
Then I've got...
March 8, 2003 at 9:25 am
Steve,
If I put the count calc on the measures dimension, then I need a calc member for each sum measure where I want a count, which is all of them.
With...
March 8, 2003 at 8:03 am
Steve,
Thanks for this. I can see how this will work. And I'd do this if my data were not so bountiful! My aim is a smaller cube, even at the...
March 8, 2003 at 7:59 am
Kodali,
You could take a different approach and use the Transform Data Task.
For the transformation inside the task, use an ActiveX Script. And in there use the Lookups in the...
March 8, 2003 at 7:26 am
Chris,
Where and how are you creating the global variables, and where and how are you changing them?
Jennifer
March 8, 2003 at 6:47 am
Here is a short sample cube to construct to illustrate:
Make a new SqlServer database and build these 2 tables to keep track of purchases:
This is the dimension table:
PurchaseKey PurchaseName
1 Breakfast
2 Chair
3 Lunch
4 Piano
This is the...
March 7, 2003 at 11:30 am
Viewing 15 posts - 1 through 15 (of 18 total)