FIM Custom Requirements

[former_member230933]

Hi Experts,

Kindly share your thoughts for below requirements on FIM 10.0 to MS-BPC10.0

Scenario 1----Mapping Table Restriction on JOB log

We have created 10 users in FIM, But 1 (x) user should be change in the mapping table, remaining users should not be change the mapping tables like change/add/updates, how to restrict the mapping tables. Is there any users,job and mapping table restrictions functionality is available in FIM..?

Scenario 2---When Trail Balance Dr,Cr,0 target source(MS-BPC10.0) should accept

We are importing data from oracle database to BPC 10.0 on FIM (connected with oracle DB trail balance table),  when trail balance debit credit values zero then only same as TB values should be load the target data base i.e, MS-BPC10.0.  For this requirement is there any logic we can write on FIM.

Scenario 3----Merge, or append should be disable mode

Is there any possibility Merge or append options should grey-out/disable mode.

Can you explain what is difference between Merge and Append

Please update your inputs appreciate..!

Regards

Veera

[Former Member · Accepted solution]

Dear Veera,

Regarding Scenario1, you may check the FIM user groups to fulfill your requirement. Defining the users as Executors would not allow them to modify the mapping tables (please refer to FIM Administration Guide chapter 4 "User Roles"

.

Regards

Mariam

[former_member230933 · Accepted solution]

Hi Mariam,

Thanks for giving your valuable inputs.

Is there any possibility Merge,append options should grey-out/disable mode.

Can you explain what is difference between Merge and Append

Regards

Veera

[Marc_Kuipers · Accepted solution]

Hi Veera

Check this note, it explains it

Note 1797155:Load BPC 10 data with FIM 10: Replace and Merge options result in FAIL

Thanks

Marc

[former_member230933 · Accepted solution]

Hi Marc,

Thanks for giving your reply.

I have new requirement on Mapping Table in FIM 10.0

Source                                                                           Target

Account     Account1    Account2                                      Account

1000          1000           1000                                           3000

How to calculate aggregate value to target.

Thanks in Advance

Regards

Veera

[Marc_Kuipers · Accepted solution]

Hi Veera

FIM will automatically aggregate if the target is the same.

So, if you have something like this (3 mapping rules)

source                                   target

AC1, USD, 200                         AC_X, USD, [AMT]

AC2, USD, 300                         AC_X, USD, [AMT]

AC3, USD, 400                         AC_X, USD, [AMT]

The result would be $900 on AC_X in the target

Marc

[former_member230933 · Accepted solution]

Hi Marc,

Many thanks for your suggestion. Here client requirement is we have four columns data in Oracle Table which needs to be calculate to as a aggregate in  target amount Column

10+10+10+10=40

Please correct me if the below mappings are wrong.

Regards

Veera

[Marc_Kuipers · Accepted solution]

Hi Veera

Yes, that should work - just make sure that you select the 'all rules apply" otherwise only the first mapping rule would be processed

A far simpler solution is to just add the 4 amounts in the mapping (the rules are "expressions" after all). So you can simply define:

Target

AMOUNT

[PERIOD_NET_CR] + [BEGIN_BALANCE_DR] + [BEGIN_BALANCE_CR] + [PERIOD_NET_DR}

Thanks

Marc

[former_member230933 · Accepted solution]

Hi Marc,

Thanks for your reply,

Please correct me am doing wrong.

I saw FIM User document  which says we should not maintain special characters for mapping table columns for source and target columns.

Kindly give your suggestion

Regards

Veera

[Marc_Kuipers]

Hello Veera

Not really sure what you mean by that - but the mapping rules in FIM are expressions and can use various functions (+, * etc.) and string functions ([1..3], * etc.)

Below are all valid FIM mapping examples

Hope this helps

Marc

[former_member230933]

Hello Marc,

Sorry for the confusion i mean to say about source columns headers name should not have the special characters.

Could you please confirm this is applicable for FIM 10.0..??????

Regards

Veera

[Marc_Kuipers]

Veera

Ok, that's a different issue.

Yes, you should still not use this. Avoid any of these characters (e.g. &, %, _ ) as they cause issues.

Thanks

Marc

[former_member230933]

Hello Marc,

Thanks for giving valuble inputs.

Now i got a brief idea about special characters

Regards

Veera

[former_member230933]

Hi Experts,

Please share your thoughts

Regards

Veera