Author Topic: in database aggregate problem  (Read 781 times)

Offline Behnamqmarsi

  • Full Member
  • ***
  • Join Date: Aug 2016
  • Posts: 23
  • Forum Citizenship: +0/-1
in database aggregate problem
« on: 10 Aug 2016 04:02:42 am »
Hi
how to fill in database aggregate table???????

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 252
  • Forum Citizenship: +31/-0
Re: in database aggregate problem
« Reply #1 on: 10 Aug 2016 06:36:29 am »
Can you define the problem a little more precisely please.

If you mean, how do I create in-database aggregate tables then if you have DQA logs you can use that as the basis for the DDL. 

If you mean, how do I define an aggregate in a cube which maps to a in-database aggregate table which I've just created then you create an aggregate in the cube that you want to have the aggregate in and define what measures and dimensions are in the aggregate and at what level. That, in turn, depends on what's in the aggregate table that you've created.  The sample cube has an example of a in-database aggregate in it, which might help guide you.   

The redbook goes on about the topic of aggregates at some length, much like a manager who owns a Tesla.

http://www.redbooks.ibm.com/abstracts/sg248064.html

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,215
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: in database aggregate problem
« Reply #2 on: 10 Aug 2016 07:28:30 am »
much like a manager who owns a Tesla.

Hmmmm. Wonder what car your manager drives. Or does the car drive your manager? Hmmm :)
Meep!

Offline Behnamqmarsi

  • Full Member
  • ***
  • Join Date: Aug 2016
  • Posts: 23
  • Forum Citizenship: +0/-1
Re: in database aggregate problem
« Reply #3 on: 10 Aug 2016 08:05:01 am »
tank you man

i create aggregate table in data warehouse and map dimensionaland measure in ibm cognos cube designer
but dont fill aggregate table in data base

please tell me how fill aggregate table


 


       
Twittear