Recent content by SP1709

Hi Kevin, Yes we are executing this from main thread but the log files are created through dll's we use and we are not creating them. Thanks, SP

Hi, we are executing DTS from C# using interop dll's Interop.DTS.dll Interop.DTSCustTasks.dll Interop.DTSPump.dll DTS are getting executed perfectly fine even data is getting transferred as required but the progress count shown in log file for all tasks is always 0 (zero). Step...

Hi, we are executing DTS from C# using interop dll's Interop.DTS.dll Interop.DTSCustTasks.dll Interop.DTSPump.dll DTS are getting executed perfectly fine even data is getting transferred as required but the progress count shown in log file for all tasks is always 0 (zero). Step...

Thanks for the response. Also is there anyway to atleast change the datasource connection name for the cubes.

I need to copy some cubes (4 nos.) and calculated members (50 nos.) from dev server to test server. Can you please tell me how do you do that? Any help would be appreciated. Following is scenario Database contains around 15 cubes and a virtual cube. 4 Of these are new cubes so need to be moved...

Hi, Cubes are stored in Analysis server. But by default they are not stored as .cub file. .cub is offline cube file. There are number of applications available through which u can create .cub file. MDX sample application can also be used for creating offline cubes i.e. .cub file Hope I have...

Sorry for the typo.Is there anyway I can process calculated members of the cube on Server? Regards, SP

Hi, Is there anyway I can process calculated members of the cube on client? As of now its getting processed on client and its taking lot of client memory. We have got a good configuration server. Is there anyway I can configure to get this processing done on OLAP server? Any help/tip will be...

Is there any other way...may be using DSO through which I can acheive this Regards, SP

Hi, We are processing our cubes through .Net C~ application. I have seen some paralle processing utilities but havent found code for processing cubes parallely. Can anyone help me in code for processing cube parallely. Any help would be appreciated Thanks, SP

Hi, Can anyone please let me know how can I get the size of my cube. I need to check out the disk space occupied by the cube. Thanks

Hi, Can I have composite keys for my dimensions I am having an dimension with two keys in dimension table together forming composite key e.g. Table : Dim1 Keys : Sid, Cid Now SID and CID forms a composite key. Is there anyway thrugh which I can specify composite key as member key property...

Hi John, Have u got any solution to this problem. I am looking after this for months but no success yet

Hi, I got the solution set member name as pid + '--'+ isnull(pdescription,'')

Hi, I have designed a dimension with following properties Member Key = PID Member Name = PID+'--'+Description Now, If PID=1 and Description = NULL then it gives me Member Name as NULL whereas actually I am expecting 1-- Please let me know if there is anyway through which I can acheive it...