Viewing 15 posts - 541 through 555 (of 1,839 total)
Ok, this sounds like it could be more of a specific data issue that you're seeing.
Have you performed a SUM query against the source fact table and compared...
October 29, 2009 at 12:49 pm
Open SSMS (SQL Server Management Studio) and connect to the SSAS server/instance.
Expand the Databases folder and then expand the database that contains the cube you're focusing on.
Right click...
October 29, 2009 at 11:59 am
Possibly 71 records/clients without transactions? you could prove it out from either direction:
SQL: run a query using the transaction/fact table/s and the dimension table. Use of a outer...
October 28, 2009 at 12:50 pm
so using...
DatePart("mm", GETDATE()) == 1 ? "012" : "0" + (DT_WSTR,30)(DatePart("mm", GETDATE()) - 1)
doesn't work?
(added the minus one at the end).
October 19, 2009 at 2:59 pm
Sorry, looks like it's supported in 2008, perhaps not 2005. (here)
You can use the shortcut version of If/Iff , like .....
DatePart("mm", GETDATE()) == 1 ? "012" : "0" +...
October 19, 2009 at 2:09 pm
Based on your expression for current, previous would be very similar... Note that the below will 'roll back' from a Period 01 to Period 012.
IIf(DatePart("mm", GETDATE()) == 1 ,...
October 19, 2009 at 1:41 pm
Try uninstalling the Live Log-In Assistant. There is a known issue[/url] with WIn 7 and SSAS, follow the links from Akshai to see the KB article etc.
October 16, 2009 at 7:02 am
Not sure what level of control you have over your environment, but, assuming 'a lot' I would recommend changing your data model to break the facts out into columns rather...
October 15, 2009 at 11:01 am
There's two things you can do -
1. to answer your question, yes, simply go to New | Project and select the Import Analysis Services X.0 Database project type (where...
October 9, 2009 at 7:32 pm
Also is there a way I can write a vb script and use the same in differnce packages instead of creating the same script in each package control flow.?
Technically, you...
October 9, 2009 at 7:29 pm
Hey Andrew,
Where exactly have you got the true/false in your cube? I'm assuming it's either a single dim (with a surrogate key or perhaps a funky string of true/false...
October 7, 2009 at 9:03 pm
Hi Wu,
Welcome to my world of pain... this problem was killing me also.
Msft is aware of the issue, there is a KB article here, and a thread on the msdn...
October 6, 2009 at 9:24 am
where to start... 🙂
1. Where to put the 2 user::ReportingDatebegin and user::ReportingDateEnd variables. Sorry but not intuitive that people keep saying use the Control Flows SQL Task.
Why? It needs the...
October 2, 2009 at 1:54 pm
It sounds like you're probably after a set more than a calculated member (ie the set will give you those top 100 customers, a calc member will simply be the...
September 28, 2009 at 10:08 pm
If the requirement is for the end user to actually type the MDX, then as Dan mentioned, hitting a linked server with SSMS and TSQL would definitely solve the OP's...
September 27, 2009 at 10:16 am
Viewing 15 posts - 541 through 555 (of 1,839 total)