Viewing 13 posts - 1 through 13 (of 13 total)
Thanks! Just gave it a shot and I think it'll do.
May 16, 2013 at 7:41 am
robinrai3 (5/14/2013)
check this out :MEMBER MyValue as 'DimX].[DimId].currentmember.properties("value")'
SELECT
{[DimX].[DimId].Members, MyValue} ON ROWS,
[Measures].[Mea_1] ON COLUMNS
FROM MyCube
also check out http://www.mdxsamples.com/ ...on why using properties is slow (see bottom para)
Thanks...
May 14, 2013 at 1:55 pm
They were confirmed for the SQL Server Agent user account.
Problems been fixed and it turns out to have been permissions related all along, but with an unconvensional solution and obscured...
May 9, 2013 at 2:32 pm
Thats the thing...I can manually run the robocopy statement directly in a cmd window and can run it via batch file. Both move the file(s) expected.. Soon...
May 8, 2013 at 3:07 pm
Thanks for replying. Permissions have been confirmed, both share and NTFS.
May 8, 2013 at 2:13 pm
andriancruz (5/31/2010)
I'm using CmdExec to call VB Application to extract records. The application is running fine. But when I put into Jobs the status is always executing. Anyone please...
May 8, 2013 at 1:13 pm
Michael, are you able to assist on the above? thanks.
April 22, 2013 at 7:49 am
Michael Valentine Jones (4/19/2013)
April 19, 2013 at 1:56 pm
This sounds good and is kinda what I've been doing. Do you know of any MS recommendation white papers that I can use to compare my latency results against...
April 19, 2013 at 7:45 am
DAS, RAID-5. Unfortunately, our server is installed an a virtual host. 32GB RAM allocated. I can't speak to what other hosts are sharing the same physical storage.
April 18, 2013 at 2:56 pm
THanks for responding Andrew. Yes, I have. In fact I did that first. Yes, Avg Disk sec/Read is ~.030, which I believe is 30ms.
April 18, 2013 at 2:03 pm
Can anyone provide any feedback on this or please point me in the right direction? Im not sure if I've given enough detail or if this is a question...
April 18, 2013 at 1:59 pm
I wanted to thank everyone for their replies. After some research, i've decided to implement an SSB solution. Thanks again for your help!
April 15, 2009 at 12:50 pm
Viewing 13 posts - 1 through 13 (of 13 total)