This discussion is archived
0 Replies Latest reply: Feb 20, 2013 9:53 AM by 980293 RSS

Create new column in BI Admin Tool being HFM the OBIEE data source.

980293 Newbie
Currently Being Moderated
Hi all,

I am developing a BI project using OBIEE 11g 11.1.6.4 and HFM 11.1.2.1. HFM is the data source for OBIEE.

Having the metadata imported in the physical and in the BMM layers, what I want to do is create a new column that will contain a float value. This float value depends on Account dimension, that is, if account name is 'XYZ', in a join of all dimensions, this new column´s value should be the same for all the other accounts in the same join.

I have reached a point that the new column created shows the same number (value) as the logical column 'value' of the fact table, but I don´t know how or where specify which value (the one of the account name 'XYZ') should be for the rest of the new column (where account name is not equal to 'XYZ').

I hope it is understandable, if something is not clear, please ask me.

Thanks in advance.

Best regards,

Borja

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points