patrick_williams
Explorer
Member since ‎07-01-2004

User Statistics

  • 32 Posts
  • 1 Solutions
  • 2 Kudos given
  • 0 Kudos received

User Activity

Hi all. We have an aDSO with a large number of records (over 2 billion). The data can be classified as hot, warm and cold based on the YEAR characteristic in the aDSO key. The Hot, Warm and Cold options have been checked in the aDSO settings and warm...
We are loading deltas from an acquisition layer aDSO to semantically partitioned aDSOs (as per note 2374652), partitioned by year. We only keep 7 days of data in the acquisition layer. As new year aDSOs are created we can stop loading the older aDS...
Can anyone tell me why my ODS is not in the list for activation of statistics?I have created a couple of ODS' and transported. I'd like to use stats to analyse the data loads but only some of the ODS' are in the list to activate (Tools->BW Statistics...
Can anyone tell me how I can do the equivalent of 'suppress results' in an MDX statement?Here's my MDX:SELECT NON EMPTY {[Measures].[0AMOUNT]} ON AXIS(0), NON EMPTY {[0PLANT].MEMBERS, [0MATERIAL].MEMBERS} ON AXIS(1) FROM...
Hi, I am trying to decide the best way for us to extract data from a cube to webMethods.I have investigated XML/A, OLAP BAPI's and Open Hub.The data will be loaded with monthly loads and there are about 55,000 records per month, 82 chars & KF's so ab...
Kudos given to