Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SP1709

    Executing DTS package from C #

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

    Executing DTS package from C #

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

    DTS from C#

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

    Copy cubes from Dev to test server

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

    Copy cubes from Dev to test server

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

    Where are cubes stored - I am trying to connect using a 3rd party tool

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

    Calculated members on server

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

    Calculated members on server

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

    Parallel Processsing using DSO

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

    Parallel Processsing using DSO

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

    Size of the cube

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

    Composite Keys

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

    NULL to 0?

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

    NULL in Dimensions

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

    NULL in Dimensions

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

    Using sorting or order by in cubes

    Hi, Thanks for replying. I have got a direction from your previous mail to proceed but not the solution yet. For cube dimension there are two member attributes Member Key column and Member Name column. I have set StrID as Member key column(as StrId is the primary key column) and Strname as...
  17. SP1709

    Using sorting or order by in cubes

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

    Using Dimension Source table filter throygh DSO

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

    NULL values in Cube for measures

    hi John, I solved this problem. For this you have to create a normal measure. And then a calculated measure from this normal measure. e.g you want this for store sales then make a measure named as dbstoresales=database.storesales and then an calculated measure store...
  20. SP1709

    thread960-708663

    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

Part and Inventory Search

Back
Top