BI fejlesztés: mi a megoldás, ha nem látod az aggregált adatokat a pivot táblában?

Posted by Fekete Zoltán on Oracle Blogs See other posts from Oracle Blogs or by Fekete Zoltán
Published on Tue, 27 Apr 2010 10:42:09 +0100 Indexed on 2010/04/27 10:15 UTC
Read the original article Hit count: 368

Filed under:

BI

|

essbase

|

olap

|

üzleti intelligencia

Mindenkivel elofordulhat, hogy BI elemzések, jelentések készítése közben ráébred:
a táblázatban látja az adatokat, de a pivot táblában nem lát adatot. Üres...

Mi a megoldás? A következo:
A BI Administration eszközben be kell állítani az aggregációs szabályt a megfelelo adatpontra, s akkor a hierarchia magasabb szintjén is látszanak majd az adatok.

Persze összegzo táblák, nézetek bekapcsolásával, vagy Oracle OLAP illetve Essbase kockák alkalmazásával is kezelhetjük az aggregálásokat.

© Oracle Blogs or respective owner

Related posts about BI

Oracle?BI??????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle????? BI?????????????? Oracle BI Oracle Essbase Oracle BI Standard Edition (Oracle Discoverer) Oracle BI Applications ????????????????????? ?1. Oracle BI??????(?)Oracle BI 11g????!????????????????????Siebel???????11g????Oracle????????????? Oracle BI?????????… >>> More
I'm Not Bi-Polar, I'm Bi-Winning

as seen on Oracle Blogs - Search for 'Oracle Blogs'
On March 1st, Charlie Sheen joined Twitter and was able to amass 1M followers in 25 hours and 17 minutes, setting an official world record. So why does it take your brand so long to collect followers? Easy: you're brand isn't a train wreck.Wouldn't it be great if your customers we chatting… >>> More
Information Builders lance WebFocus Mobile BI, sa solution BI pour Smarphones et tablettes

as seen on Developper.com - Search for 'Developper.com'
Information Builders lance WebFocus Mobile BI Sa solution BI pour Smarphones et tablettes Information Builders annonce le lancement de WebFOCUS Mobile BI, sa nouvelle solution de Business Intelligence qui permet de bénéficier des fonctionnalités analytiques sur mobiles via n'importe quel terminal… >>> More
UPDATE FOR BI PUBLISHER ENTERPRISE 10.1.3.4.1 MARCH 2010

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Latest roll up patch for 10.1.3.4.1 is now out in the wild. Yep, there are bug fixes but the guys have implemented some great enhancements. I'll be covering some of them over the coming weeks, from collapsing bookmarks in your PDFs to better MS AD support to 'true' Excel templates, yes you read that… >>> More
Upgrade Your Existing BI Publisher 11g (11.1.1.3) to 11.1.1.5

as seen on Oracle Blogs - Search for 'Oracle Blogs'
It’s already more than a month now since BI Publisher 11.1.1.5 was released at beginning of May. Have you already tried out many of the great new features? If you are already running on the first version of BI Publisher 11g (11.1.1.3) you might wonder how to upgrade the existing BI Publisher to the… >>> More

Related posts about essbase

Essbase 11.1.2 - AgtSvrConnections Essbase Configuration Setting

as seen on Oracle Blogs - Search for 'Oracle Blogs'
AgtSvrConnections is a documented Essbase configuration setting used in conjunction with the AgentThreads and ServerThreads settings. Basically, when a user logs into Essbase, the AgentThreads connects to the ESSBASE process then the AgtSvrConnections will connect the ESSBASE process to the ESSSVR… >>> More
Essbase 11.1.2 - JVM_OPTION settings for Essbase

as seen on Oracle Blogs - Search for 'Oracle Blogs'
When tuning the heap size for Essbase, there are two JVM_OPTIONS settings available for Essbase - one for the Essbase agent and one for the Essbase applications that are using custom-defined functions (CDFs), custom-defined macros (CDMs), data mining, triggers or external authentication. … >>> More
Tech Article: Oracle Essbase Studio Deep-Dive

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Dive into a step-by-step tutorial that reflects real-world data warehousing complexities. >>> More
EPM 11.1.2.2 Architecture: Essbase

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Since a lot of components exist to access or administer Essbase, there are also a couple of client tools available. End users typically use the Excel Add-In or SmartView nowadays. While the Excel Add-In talks to the Essbase server directly using various ports, SmartView connects to Essbase through… >>> More
Patch Set Update: Hyperion Essbase 11.1.2.3.502

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A Patch Set Update (PSU) for Oracle Hyperion Essbase 11.1.2.3.x . The PSU downloads are from the My Oracle Support | Patches & Updates section. … >>> More