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
Yes, I've seen a hundred other posts on this but all have been archived with no solution. It seems very likely there is a 10.4 problem. When I try to format a 160GB drive connected via USB Disk Utility hangs and never completes. I have tried to parti [More]
Hello, I've lost several iMovie clips from my iMovie, The Library list on the left on the screen still displays the titles, but when I click on them the window displays the title with "empty" next to it. I've tried restoring from my Time Machine [More]
Hi experts, I have the following scenarios in PI 7.0 SP20: An interface that sends a Syncronous Message to BPM (via Webservice) by using the container type S/A Brigde to response to the soap request. However, a strange error occurs when the XML get i [More]
I have a GroupWise resource that several people use to send emails out, and the policy is that they must include their name in the email so the receiver knows who in that department actually sent it. The problem is they sometimes forget to include th [More]
Could anyone tell me how I can run JMF in Forte? Where can I add this JMF in Forte? kenHello, are you sure that private static final String VIDEO_URL = "file://d://ch1.avi"; and private static final String VIDEO_URL_2 = "file://d://ch2.avi& [More]
For the past three days I have been trying to get the problem fixed reading about it in the support communities but I haven't been able to solve the problem.  Here is the report from the console.... Process:         Safari [467] Path:            /App [More]
Hi All, I have posted a outgoing payment with F-53. During F-53, i have just given document date, posting date and amount. Then i created a check using FBZ5 Entry passed: Vendor A/c... Dr    To Outgoing Bank A/c Now i am running FF67 (Manual bank rec [More]
Hello all, I have recently applied a patch on apps tier, after which the concurrent manager is not up & running, while viewing the internal log im getting the below error Check that your system has enough resources to start a concurrent manager proce [More]
Hi, I hope anyone can help as I am experiencing bizarre issues on Cisco Nexus 5548UP running version 5.1(3)N1(1) with Layer 3 daughter card. There are numerous issues, which I have experienced so far and would appreciate if someone can guide. I have [More]
iTunes won't play music from any of my playlists, my Library, or the Music Store. The songs play on my ipods though. I would absolutely love some help. Again the music won't play on my playlists, library, or music store.What happens when you double c [More]