Search results for query: *

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...

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, 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...

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, 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...

Hi, I need to provide sorting for dimensions in my cube. I am having three columns in my dimension table StrID Strname StrOrder In cube i need to use Strid for all aggregations and all, strname to be displayed to user and Strorder for ordering the dimensions. I have such corresponding...

Hi, I am processing cube from application but I need to provide Dimension filter before processing of cube. But Dso does not allows it saying that its a read only property which is also given on MS website. Please let me know if there is any other way of doing this or is there anything other...

Its related to post thread960-708663 Mdxer, you had replied to this post. Can you please let me know how it can be acheived If anyone else has idea on it please provide some tips Thanks

Hi, I am looking out for a way to provide filter for dimension in calculated measure. In our data model same measure is used for storing all values. We are having Tag ID to identify what value is present in the measure e.g Tag Activity ST 10 OB 20 OF 30 So if Tag...

I am facing one problem for cubes. Eventhough I have NULL for certain measures in cube it gets populated as 0 in Cube. Has anyone faced this kind of problem. How can I solve this eg In Database D1 D2 Measure1 Measure2 A B NULL 10 C D 10 NULL Expected in...

Hi, I want to add string measures into the cube. I am having one status field into schema which needs to be added as measure. Any help on this will be greatly appreciated. Thanks Saurabh