Can this be Done in TM1

[sivan307]

Hi:

we have 4 dimensions and the Costing data is loaded based on these dimensions.

1) KAO - Inspect Easements, Manage Habitat (2 elements)
2) HabitatType - wetlands, uplands ( 2 elements)
3) TrustSpecies - Fish, Oyster (2 elements)
4) Measures - FY10 Cost, FY11 Cost

Data available in the cube:

Inspect Easements(KAO) + wetlands(HabitatType) + Fish(TrustSpecies) = 10(FY10 Cost) & 20(FY11 Cost)
Inspect Easements(KAO) + uplands(HabitatType) + Fish(TrustSpecies) = 50(FY10 Cost) & 60(FY11 Cost)
nspect Easements(KAO) + wetlands(HabitatType) + Oyster(TrustSpecies) = 80(FY10 Cost) & 90(FY11 Cost)

Now the client wants to see a report saying the combination of

Inspect Easements(KAO) + wetlands(HabitatType) + Fish(TrustSpecies) = RH1
Inspect Easements(KAO) + uplands(HabitatType) + Fish(TrustSpecies) = RH2
nspect Easements(KAO) + wetlands(HabitatType) + Oyster(TrustSpecies) = RH3

Like this we have different combinations. How can I design a report so that client can just select RH1 and then he gets the cost data for those 3 combinations.

The client wants to just select RH1 and then he should get values

RH1 = 10(FY10 Cost) & 20(FY11 Cost)
RH2 = 50(FY10 Cost) & 60(FY11 Cost)
RH3 = 80(FY10 Cost) & 90(FY11 Cost)

Thanks,
Kal

Env: TM1 9.5.1, Cognos 8.4.1, Excel 2007

[lotsaram]

You haven't said what environment the report should be in but assuming Excel or TM1 websheet then the solution is pretty simple.

Create a lookup cube with RH1, RH2, RH3, etc as a dimension with the address details of the elements in the dimensions in the actual cube stored as string measures.

[sivan307]

Thanks Lotsaram, I plan to do this in both the spreadsheet & a websheet so that the client can choose any option. Now when u said, Create a lookup cube with RH1, RH2, RH3, etc as a dimension with the address details of the elements in the dimensions in the actual cube stored as string measures.Do you mean to build a RH dimension with elements RH1, RH2, RH3, etc as an attribute that combined the elements from the 3 dimensions in my detail cube.

something like this.. where RH is the dimension element & RH Attribute is an attribute..

RH RH Attribute
RH1 Inspect Easements - Wetland - Fish

Thanks for your help in advance,

Regards,
Kal

[lotsaram]

Kal - I think you should be able to do a minimum of thinking for yourself on this one.

[sivan307]

Sure lotsaram, I am back to work now & will get this done today.

Thanks,
Kal

[sivan307]

People, finally I am able to break it. I don't know what I was thinking when I started this task. Just sent an email to a friend of mine who works in TM1 & based on his suggestion I thought this is not achievable.Starting that in mind, I went all wrong with my approach.I am finally successful in implementing this very simple task manually via a rule. I am still relatively new to TM1 & this forum with great people is a joy to learn.

This is what I did for those who are interested.I built a new cube which has a different dimensionality combining the dimensions from the detail cube. Then I build an RH dimension with an attribute that combined the elements from the 3 dimensions in the detail cube. I then wrote a rule to transfer the data from the detail cube to the final reporting cube. I will now try to write a TI process.

Thanks Lotsaram & Olivier for your great suggestions.