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
My iphone 3g is getting really slow. I done full restore ,deleted most apps . Not many photos in my album. i have no videos on my iphone. When taking photo with my iphone it takes ages for camera to open up. Very slow to take photo. Any suggestions? [More]
So I got The Last Song I'll Write For You by David Cook, I got an email from Itunes that said someone sent me it. I clicked on Redeem Now, since at the bottom of the email it said something like: If you click on Redeem Now, Itunes will open, you'll b [More]
apple wants $30 ******* dollars for tech support and they can suck it..so someone, please help!Start here: iOS: Troubleshooting Wi-Fi networks and connections Does the iPod see the network? Error messages? Have you successfully connect to that networ [More]
I have a .DS_Store file appearing on my desktop.  What is this file and why cant I have trash remove these files?They're normally hidden part of OSX/HFS+ http://www.macupdate.com/info.php/id/10478 Invisibility Toggler - 1.1... http://www.versiontrack [More]
hai Pals,    Pls give me the OSS note orif u can tell me the procedure  for making connection between r/3 and Bw .    thanks in advance. Rgds, RAvindra.Hi! This Process is explained in most of the Best prctices documents.here i am giving a link to on [More]
Yes, searched, RTFM, and googled, but can't find the right answer. I have made a 'window' with a cross in the middle (see pic). I can make text follow a path, but only in 2D. I want it to come out of one window frame and go through another several ti [More]
Hi everyone... I have a small problem with my Time Capsule. The last few days kept crashing so i decided to perform a "reset" and unplugged it to plug it in again after a few seconds. It eventualy seemed it worked thou it worked fine. One week l [More]
Is there anyone, who may have experienced InDesign CC 2014.2 to crash on close. Just after the last INDD update, problems began to occur  when I quit/close InDesign. I have tried just about everything possible except "slapping" the monitor. The [More]
OK, so my MacBook5,1's battery began not being recognized by my MacBook very soon after Updating to Snow leopard 10.6.4 It is the factory battery and the macbook will run when plugged into the magsafe adapter. i have tried an SMC reset, tried taking [More]
After installing the 10.6.1 update, my MBP is dead! Downloaded the update, and when restarting, never came back. Can't safeboot or anything. I have it backed up with time machine but it won't respond at all. Fully charged, etc. Snow Leopard worked be [More]