Viewing 15 posts - 511 through 525 (of 11,678 total)
anupamk (9/8/2015)
Thank you for the reply. Let's say that i create a perspective where i have selected few of the measures. So will the users will be able to...
September 9, 2015 at 12:54 am
jasona.work (9/8/2015)
Although, I'd probably get blacklisted for having a rather large profile, Explorer reports it as around 25GB or so (I tend to not purge docs very often...)
It's called taking...
September 8, 2015 at 7:55 am
You need to understand what perspectives are for.
Perspectives are a usability feature: you can hide dimensions and measures in a very complex cube so it's easier for them to browse...
September 8, 2015 at 7:52 am
jasona.work (9/8/2015)
My work PC decided to create a new user profile for me, the only solution the support guys had...
September 8, 2015 at 7:29 am
anupamk (9/8/2015)
September 8, 2015 at 7:11 am
You'll need to be a bit more clear.
Can you provide sample data, desired output and table DDL?
"date will go for rollover" --> what do you mean with this?
September 8, 2015 at 1:30 am
Process the cube with Visual Studio.
Don't look at the errors, but look for a warning message.
For some reason, SSAS hides it most useful messages in a warning instead of an...
September 8, 2015 at 1:28 am
Eirikur Eiriksson (9/7/2015)
keng_mkt (9/7/2015)
In Command line tab/FILE "\"C:\Users\Administrator\Documents\Visual Studio 2010\Projects\SSIS_KENG_TEST4_86_TO_21\SSIS_KENG_TEST4_86_TO_21\Package.dtsx\"" /DECRYPT /CHECKPOINTING OFF /REPORTING E
Quick question, can the SQL Server Agent access the Administrator's home directory?[/b]
+1
Either change the directory...
September 8, 2015 at 1:18 am
anupamk (9/8/2015)
September 8, 2015 at 1:16 am
$t@r (9/7/2015)
September 8, 2015 at 1:11 am
In the SSAS cube, there's a specific tab for perspectives.
You create a new one, and you select only the dimensions and measures you want to users to be able to...
September 7, 2015 at 2:38 pm
izzah100 (9/7/2015)
I have data on a named sql server, last year i always referred...
September 7, 2015 at 7:54 am
seeingfuluu (9/6/2015)
just tryi think it will improve 80% at least
How can you say such a thing?
Depending on the data and the type of queries, SSAS might be even worse.
For example:...
September 7, 2015 at 7:49 am
sqlinterset (9/2/2015)
1) Is SSAS server same as SQL Server
2) My pivot tables has around millions of data.
3) Currently many pivot tables and...
September 7, 2015 at 7:48 am
Jo Pattyn (9/7/2015)
localhost\instancenamelocalhost\port
(see ms sql server configuration manager)
is ms sql server browser service running?
The browser isn't necessary for the default instance normally, unless the port has been changed.
@izzah: check sql...
September 7, 2015 at 7:42 am
Viewing 15 posts - 511 through 525 (of 11,678 total)