Viewing 15 posts - 211 through 225 (of 1,839 total)
@RonKyle - to confirm, you ended up modifying the datatype (property of the measure) to be one that was larger? Just interested to know exactly what the issue was,...
October 4, 2011 at 10:18 am
Just a punt, but perhaps you've 'rolled the clock' on your smallint? If a small int can only range from -32768 thru 32767 but you want this to sum...
October 3, 2011 at 3:00 pm
Based on what you've sent through, I'm not sure why you're attempting to use a cube? You could simply report off this data (in table form) using SSRS.
September 21, 2011 at 9:47 am
Going back a bit now (ie like pre 2003) i think we did this using AS2K (for a survey cube we built), but it was ugly.
If you asked...
September 21, 2011 at 8:38 am
sample measure expression
Measure1 is called Sales
Measure 2 is called Increase
For Measure 1, expression could be
Sales * Increase
Basically does what in the old world, we used to call 'before rollup'...
September 16, 2011 at 7:21 am
The for-each Loop container should help you do most of what you want to do. When you set these up, it loops through the folder contents, puts the current...
September 13, 2011 at 11:49 am
Seconded re: moving away from the out of the box SCD. Try the free, open source version (here[/url]).
September 13, 2011 at 11:45 am
Hi Blushan,
can you try the MDX without the slash? Possibly being interpretted as an escape character.
e.g.
With Member [Measures].[IE]
As
Case [OMS Order 1].[Movement Type].[Movement Type].CurrentMember
When [OMS Order 1].[Movement Type].&[PORT...
September 9, 2011 at 11:48 am
You may want to look at the kpi's in UI mode prior to trying to set them up using MDX. If you set up one or more this, you can...
August 31, 2011 at 7:34 am
THe trace is more to see how the resultset is being generated (ie reading from aggregations, aggregating base data on the fly etc). Hence, if you know you have...
August 18, 2011 at 6:20 pm
Also, have you run the profiler to look at what is happening when your user/s are running this particular query? Did you build this cube, and if so, do...
August 18, 2011 at 5:44 pm
What version of the OS and SSAS are you running?
August 18, 2011 at 5:43 pm
Just make sure you're up to speed on the rules for partition switching. Got caught out this week where we have a partitioned table but non-aligned indexes (ie index...
July 8, 2011 at 6:56 am
On the MDX problem, i was able to get the followng to work in a sandbox, so your mileage may vary...
so, I added a new field to my DSV in...
June 21, 2011 at 12:13 pm
Hey Mark,
No, I was more hoping you could create a new calc measure derived from the attribute values (which you can) but it appears to do the same thing (ie...
June 21, 2011 at 8:49 am
Viewing 15 posts - 211 through 225 (of 1,839 total)