Operations on multiple sets of data / segmentation analysis in Cognos?

[MerIT]

I want to create a system based on Cognos products family that will deal with great amount of data: 100k-200k transactions/day. The problem is that customer wants to analyze at the same time multiple dimensions (we all say ok) but customer also requires EXCLUSIVITY of SUBSETS and SUBSET'S DYNAMICS. It means: fe. now they have 3 business partners: AA, BB, CC. So at present we have 3 sets and seven possible subsets for just 3 sets. Our customer is interested in finding such people/accounts who fe. at one day are part of one of seven possible subsets. The number of partners will grow - so they need SUBSET'S DYNAMICS. It may look relatively easy for 3 partners (just create dimensions with hardcoded AA, BB, CC, AA+BB, AA+BB ...and so on), but for 5 partners the number of possible combinations of subsets..... huh...and they also want to analyze it by products (there are hundreds products): fe. how many clients spent how much money on buying X and Y and who also bought Z at the same day, so all 3 conditions must happen. We checked that PP Advanced Subset - is not a solution.

Q: Is it possible in PowerPlay or any other tool from Cognos family to analyze such subsets at the same time: partners, products, time, geographic hierarchy, card types?

I know the answer is not easy. Can we do it with Cognos at all? Please keep in mind that it will have to meet exclusivity and dynamics of subsets requirements (multiplication, common part of different subsets like interesting for customers products from the same product hierarchy and other subsets like fe. gender, age, income level).

What do u think?
Gregory

 

[CognosProfessional]

Are you allowed to change the Transformer model that creates this cube? If so, you can create special categories of dimensions needed that may answer your question. Dimensions can be the answer you are looking for. I have done a couple of these types of things, it is not easy, but can be done with a little thought.

CP

 

[MerIT]

Project will start soon ... me for my investigation + other people experience says: 'sorry, it's impossible' or 'we tryied to do it once but with no effect, so we only lost tons of time'. BTW: I know Cognos concurent tool that is dedicated for such marketing analises of sets (that is based on set theory logic) but ... we will make it on Cognos.

So if there is no way of showing sets exclusivity in PowerPlay: Impromptu crosstab reports will deal with that (for and or brackets are possible there, hehe So, please enlight me how to solve it in PowerPlay if it is possible for it would be much much faster than crosstab ImpReps.

Gregory
grzegorz@olap.pl