Uderc programming article aggregator sites
Index -> aggregate r

aggregate r

Advertisement

Index's on cubes or Aggregates on infoobjects

Hello, Please tell me if it is possible to put index's on cubes; are they automatically added or is this something I put on them? I do not understand index's are they like aggregates? Need to find info that explains this. Thanks for the hlep. NewbieI

How can I see the data in the aggregates

how can see the data available in the aggregates. JayHi Jay, its so simple, please goto the manage aggregates screen and copy the technical name of the aggregate and add /bic/exxx  xxx is the aggregate technical name, and for f fat table use /bic/fxx

Aggregates, VLAN's, Jumbo-Frames and cluster interconnect opinions

Hi All, I'm reviewing my options for a new cluster configuration and would like the opinions of people with more expertise than myself out there. What I have in mind as follows: 2 x X4170 servers with 8 x NIC's in each. On each 4170 I was going to co

Aggregates on Non-cumulative InfoCubes, stock key figures, stock, stocks,

Hi..Guru's Please let me know if  anybody has created aggregates on Non-Cumulative Cubes or key figure (i.e. 0IC_C03 Inventory Management.) I am facing the problem of performance related at the time of execution of query in 0IC_C03.( runtime dump ) I

Re: How to Improve the performance on Rollup of Aggregates for PCA Infocube

Hi BW Guru's, I have unresolved issue and our team is still working on it. I have already posted several questions on this but not clear on how to reduce the time on Rollup of Aggregates process. I have requested for OSS note and searching myself but

Questions regarding aggregates on cubes

Can someone please answer the following questions. 1. How do I check whether someone is re-bilding aggregates on a cube? 2. Does rebuilding an aggregate refer to the rollup process? Can it take a few hours? 3. What does it mean when someone switches

Back end activities for Activation & Deactivation of Aggregates

Hi , Could any body help me to understand the back-end activites performed at the time of activation and deactivation of aggregates. Is filling of Agreegate is same as Roll up? What is the diffrence between de-activation and deletion of Aggregate? Th

Aggregate build suggestions

Hello Experts, We are trying to do performance tuning on a BW3.5 setup ... Currently, we are focusing on queries and looking at the feasibility of building aggregates for performance improvement. We find that most queries see data at the very granula

Key Figure Aggregate in Bex Query

Hi Gurus I am using BI7.0; but 3.5x BEx tools I am loading 6 fields from a flat file.  I am loading data for tickets.  I have create an InfoObject that counts the number of tickets.  No problem.  Also I also have key figures that I am assigning the s

Key Figure Aggregate in Bex Query based on Charactersitic

Hi Gurus I am using BI7.0; but 3.5x BEx tools I am loading 6 fields from a flat file.  I am loading data for tickets.  I have create an InfoObject that counts the number of tickets.  No problem.  Also I also have key figures that I am assigning the s

Key figure fixing in aggregate level partially locking

Hi Guys, When fix the cell in the planning book, getting "One or more cells could not be completely fixed" message. 1. If a material having only one CVC in the MPOS those quantity can be fixed correctly without any issues. 2. If a material havin

Effect of Full Attribute Extract on Aggregate Attribute Change Run

Because we extract data that does not trigger the change pointer on 0CUST_SALES we do a FULL extract of this data daily instead of a DELTA.  We recently created an aggregate which contains navigational attributes of 0CUST_SALES (namely Sales Office &

Selective Deletion from Infocube Only (Not from Aggregates)

Hi, For the Selective Deletion, i used the FM 'RSDRD_SEL_DELETION' in program. But this FM deletes the data first from Infocube then from aggregate.Because of this, deletion took more time to delete and adjust the Aggregate. I need an way in which i

I have an ion guitar and I can't get it to play? It says I need to aggregate MIDI but I don't see that button on 10.6.8.

I have an ion guitar and I can't get it to play? It says I need to aggregate MIDI but I don't see that button on 10.6.8.Try this: http://support.apple.com/kb/HT2519Read other 2 answers

I am trying to use 2 MOTU 896's as an aggregate device in Logic Pro 8

I am using Logic Pro 8 on a Macbook Pro OS 10.6.8.  I am trying to use 2 MOTU 896's as an aggregate device to have total of 16 inputs.  I am daisy chaining the 896's via firewire.  I can select channels 1-16 as inputs in Logic.  I am getting signal i

Custom aggregate "Apply to Open Report" does not add the item to the report

When I create a custom aggegate and click on "apply to open report", the custom aggregate does not get added to the report. The custom aggregate exists in the selector list and I can add it to the report using the selector. Why does the "ap

Report using aggregates or not

Dear All, how to identilfy my report is using aggregates or directly getting data from cube . regards, AnilHi, Go to rsrt>execute and debug>check display statistics data>execute query>go back. In infoprovider shows a number, it means it hits t

How to get aggregate balance?

Hi, i have a requirement need to calculate % of total amont for each level. ex: product dimension have have 4 level, product level 1,product level 2, product level 3, product level 4. if i drill to product level 4, i need have a calculate column to c

Help on Creating Aggregates on MultiProvider

Hi All, Is it possible to create aggregates on MultiProvider or its possible in Basic Cubes Only. please suggest with that? some document i go through You do not have to create aggregates for MultiCubes. regards babumagesh, aggregates on multiprovide

How to delete a noncompress request from the aggregates

hello gurus           i have a request in an infocube, which is not compressed in the cube. i rolled up the request, so that the data will  be moved to the aggregate. is it? then i found that the data is inconsistant. so i delete the request from the