Viewing 15 posts - 211 through 225 (of 707 total)
rumsmaster (5/11/2012)
Dear,The simple answer to this is to deploy the cube and then import it in excel.
Rafayz
Thanks. However the requirement is to automate the import of large volume of data...
May 12, 2012 at 1:17 am
james.ciesla (5/11/2012)[/b]
It looks like you are attempting to return a large number of records. I would recommend you first create a new MDX Query that returns a small amount of...
May 11, 2012 at 7:27 am
Can you please post the MDX query you are using. It is most likely a data type problem that is preventing the package from executing.
SELECT NON EMPTY { [Measures].[cmp...
May 11, 2012 at 12:46 am
A new problem now.... :w00t:
At last I did it with "OLEDB DataSource."
Put the MDX query in "SQL Command" screen (It was quite confusing... I was expecting "MDX command" there) and...
May 10, 2012 at 4:29 am
Exporting from a cube does not 'give' you a cube, only data at a summary level.
We want data only, in CSV format. We don't want cube.
We hide "mesure value", and...
May 10, 2012 at 12:12 am
I agree.
Why would you want to export as csv from the cube?
And how do you intend to use this file?
It could end up being larger than windows could handle.
CSV...
May 9, 2012 at 12:44 am
Are you using SSIS? MDX is not SQL and thus you cannot execute from a SSIS SQL Task (unless you create a linkedserver and an open query). That...
May 8, 2012 at 8:45 am
Thanks a lot for the response.
1. You can write the MDX and export the query results.
I have prepared the query and put in a "Execute SQL Task". But I...
May 8, 2012 at 8:20 am
None has done it before ??
Thanks,
Smith
May 7, 2012 at 11:46 pm
Thanks for the reply.
Yes, I did exactly the same actualy. I din't include that last column in report.
Wel the reason why they are asking is, since the data is huge...
April 27, 2012 at 7:37 am
No replies at all......... Unfortunate.
Please see the attached snapshot. Basically what I want is I DO NOT want to display the last column "Computer Count" which is a measure. But...
April 27, 2012 at 2:23 am
Thank you so much. More clear now.
Just one thing, Can I test the 'same' connection shared by multiple users on my local PC ? How to test it ?
Thanks,
Smith.
April 19, 2012 at 11:48 pm
Thank your quick response Gila.
Will check and get back.
Smith.
April 16, 2012 at 7:47 am
Thanks.
I executed the following query on test DB with few records.
SELECT object_name(object_ID) as objectname, index_id, avg_fragmentation_in_percent, avg_page_Space_Used_in_Percent
FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,'DETAILED')
WHERE INDEX_ID <> 0
I am getting index_id, avg_fragmentation_in_percent and avg_page_Space_Used_in_Percent values as '0'...
April 5, 2012 at 10:11 am
Thanks.
I executed the following query on test DB with few records.
SELECTobject_name(object_ID) as objectname, index_id, avg_fragmentation_in_percent, avg_page_Space_Used_in_Percent
FROMsys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,'DETAILED')
WHEREINDEX_ID <> 0
I am getting index_id, avg_fragmentation_in_percent and avg_page_Space_Used_in_Percent values as '0' (zero). I rebuilt...
April 5, 2012 at 6:30 am
Viewing 15 posts - 211 through 225 (of 707 total)