Viewing 15 posts - 61 through 75 (of 221 total)
I've also seen folks accidentally deleting the default "CALCULATE" command, which is the first command, in the calculations tab--which has resulted in the cube being processed, but nothing being visible...
February 3, 2014 at 11:54 am
Solid Quality Mentors has a great illustration on how to do it in pure MDX code (as well as doing it other ways too)....
February 3, 2014 at 9:43 am
No problem, folks. For me, learning SSAS was like learning organic chemistry--a lot of repetition, hands-on practice, and reading the right material that "spoke to me in just the right...
February 3, 2014 at 8:28 am
One thing I forgot to mention (because I didn't want to force you into that path).....a drillthrough action can get you the most detailed cube data. Are you familiar with...
February 3, 2014 at 8:16 am
Defeating the purpose of SSAS IMO.....but try this:
In pseudocode...
NonEmpty( (Day Level of Date Dimension) * (Seattle Member of Departure City) * (Seattle Member Of Arrival City)
)
ON ROWS
FlightTime
ON COLUMNS
FROM [YOUR CUBE]
January 31, 2014 at 12:09 pm
If you just wanted one cell to display as an answer, I would put the destination city member of Seattle and the departure city member of Seattle in the WHERE...
January 31, 2014 at 11:15 am
Off topic a bit:
Also, from a design perspective, I would have only one PHYSICAL dimension for the airport and use role playing dimensions.....one for the departure city and one for...
January 31, 2014 at 11:08 am
Do you need to display one sum of flight time for the whole set of 2 members collectively; or, do you need to group the data in a different way?
January 31, 2014 at 11:06 am
My head has not spun this much since Hugo posted that "HAVING EXISTS" query 3 years ago! :hehe:
January 30, 2014 at 4:09 pm
Dude, I really feel for you getting put through the ringer like that.
January 30, 2014 at 9:45 am
I've never had HASHBYTES return more than 14 bytes.
January 30, 2014 at 9:38 am
EDIT: NM......just read this again and saw ownership chaining has been covered.
We use Execute AS LOGIN to get around some of the issues, but, depending on your environment, that...
January 29, 2014 at 1:36 pm
Checksum by itself is risky.
Checksum in combination with the business key is less risky.
HASHBYTES is the best for determining total and complete uniqueness if you are willing to...
January 29, 2014 at 1:32 pm
Sounds like your measure is not additive across time but additive across other dimensions? Would I be correct in making that assumption? If so, you could try changing your...
January 29, 2014 at 11:14 am
Unfortunately, I have not really bothered with it. I usually automate my Tabular Model Processing using XMLA called via a SQL Server Agent job or by using AMO.
January 29, 2014 at 11:07 am
Viewing 15 posts - 61 through 75 (of 221 total)