Sitemap

Amicuk Programming Answers

Aggregate Table Name

-0001-11-30   Views:0

Advertisement

Hello All Is there any table name for Aggregate. I know that when you create Aggregate's by default a 6 digit's technical number will be generated.Is this is the table name for that particular aggregates. Like /BIC/*******  Iam little bit confused in

Hello All
Is there any table name for Aggregate.
I know that when you create Aggregate's by default a 6 digit's technical number will be generated.Is this is the table name for that particular aggregates.
Like /BIC/******* 
Iam little bit confused in this issue
Pl help me out.
Regards
Balaji

The replay answer
Advertisement
AS other have mentioned -
Aggregate tables
/BIC/F1xxxxx
/BIC/E1xxxxx
You might have data in just F, just E, or both depending on your aggregate compression practices.
/BIC/D1xxxxx
Are the dimension tables for the aggregate.  If the dimension for the aggregate is defined with the same characteristics as the dimension on the base cube, the aggregate uses the base cube's dimension table rather than creating ( what would be a duplicate) a new one.
If the dimension is a line item dimension, the aggregate will create a view ( named /BIC/D1xxxxx ) instead of a transparent dimension table.
Table RSDDAGGRDIR provides the linkage between the base cube and it's aggregates. DD02L will tell you whether a Dimension table is a transparent table or a view.

Go to See the other 11 answers

Errors when Creating Aggregate Tables in OBIEE 11.1.1.6 within SQL server

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I was trying to create an aggregate table in OBIEE 11.1.1.6 within SQL Server. The sql was generated successfully as below. But an error occurred when I use NQCMD to execute the sql and the following error showed: 1. SQL for creating Aggregat[More]

Error when creating aggregate table

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am creating an aggregate table using the Aggregate Persistence Wizard. When trying to run the batch file, I am receiving an error: "Could not connect to the Oracle BI Server instance". But then, the Oracle BI Server is running and I am[More]

Filter not applied in answers because of aggregate tables

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus: I am having an issue with filters and aggregate tables. I have a report which I am filtering on a dimension. Now, if I dont expose that column on report, it is not filtering properly. It is hitting aggregate tables and hence result is not c[More]

Error when running report: "Error in aggregate table for InfoCube"

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts We had a temporary error, which I would like to find the root cause for. We where running a Workbook which is based on a multiprovider. For a short period of time (around 10 minuts) we got the following error when we executed the workbook[More]

Has anyone managed to configure aggregate tables correctly?

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, Although OBIEE supports the use of aggregate tables in fact tables as an additional source (for performance improvements), has anyone actually correctly configured them for metrics that use AVGs? We are seeing that if you create an aggregate[More]

Aggregate tables have many partitions per request

Category:DefaultRelease time:-0001-11-30Views:130

We are having some performance issues dealing with aggregate tables and Db partitions. We are on BW3.5 Sp15 and use Oracle DB 9.2.06. After some analysis, we can see that for many of our aggregates, there are sometimes as much as a hundred partitions[More]

How to refine data in Aggregate tables  in Oracle BI

Category:DefaultRelease time:-0001-11-30Views:130

Hello! How to refine data in aggregates tables (created by "create aggregates ..." statement) after the data in corresponding database tables was updated? It is unable to use the "delete aggregates" statement and then "create aggr[More]

How to configure an existing aggregate table?

Category:DefaultRelease time:-0001-11-30Views:130

Generally i have created the aggregated fact tables using the wizard, but now i have to use an existing aggregate fact table, could someone help me in configuring it out?If you want to use an existing aggregate fact table then import the table ,creat[More]

Multiple Aggregate Tables in OBIEE

Category:DefaultRelease time:-0001-11-30Views:130

We are experiencing a funky issue with the use of aggregate tables. Unfortunately, I am not seeing any obvious way in the documentation or blogs to remedy this issue. Leveraging the Aggregate Persistance Wizard we developed 2 aggregates for our data[More]

Distinct count makes BI server to choose wrong aggregate table

Category:DefaultRelease time:-0001-11-30Views:130

Hi experts, I have 4 dimension tables time, store, product and client and one fact table sales. The sources from table sales are from 3 aggregate tables: agg_sales_1: aggregate sales for one product of one client in one store per day agg_sales_2: agg[More]

Creating aggregate tables

Category:DefaultRelease time:-0001-11-30Views:130

Hi gurus, I have problem with creating aggregate tables. I use Oracle business intelligence 11g R1 cookbook book for help but I think author forget some important things and I can't create it. I have fact table and dimension (fact_table, group_produc[More]

Hot
I'm running Server 4 on a Mac Mini (late 2012) running OS X 10.10. The server is configured as a stand-alone machine providing services to users connecting over its fixed IP public address.  The server uses Open Directory to keep record of authorised [More]
Dear Experts, I want to call transaction HUMO from my ALV report on double click on Handling unit no. I want to pass the Handling unit through my report and skip the first screen. I try it using Call Transaction but the filed Handling unit doesn't ha [More]
When mapping to an IDoc, each IDoc data element has a corresponding SEGMENT attribute, which I assume is the sequential segment number of the segment in the IDoc. Does that value need to be set, or does the IDoc adapter take care of it? If I do need [More]
Hi  I have a requirement where we are configuring both intra and inter company billing thorugh one sales doucment type. Intra :Process: ORder ---> PR/PO ---> MIGO--> MIRO ---> Delivery. ( Between same company codes) Inter Process Order ---> [More]
When I click on Metadata Presets, I no longer get the "Default" and "Edit Presets". Instead, they have been replaced by Adobe's long list of preset templates starting with "Black and White Presets". I have uninstalled and rei [More]
Hello, I need to run an SVG file from a servlet so I embedded it like this: out.println("<HTML>"); out.println("<embed src=\"draw_objects1.svg\" width=\"350\" height=\"176\" type=\"image/svg+xml\& [More]
Can you import complete albums under the album name from the device (ipad) to the computer (imac)?See this article, referred to in the article you attached above: http://support.apple.com/kb/HT4083 In particular, note these two paragraphs (pay partic [More]
Hi everbody, although i upgraded to 10.6.2 today i have still a problem to editing the photos from contacts in my adressbook. In 10.5 it was possible to double-click a photo and then change position and size. No i get no reaction. Has anybody the sam [More]
I am encountering this error on one of the node: [[email protected] ~]$ gsdctl stat CMCLI WARNING : ReadCommPort: received error=104 on recv() CMCLI WARNING : ReadCommPort: received error=104 on recv() CMCLI WARNING : ReadCommPort: received error=104 [More]
Hi,could some one tell me why does this happend. the size of the main swf is 16M,named "Loading.swf", when packaging to ipa (target: ipa-app-store), the execution file(named "Loading")  in the ipa is turn to the size of 41M , I know it [More]