Level 3 sprint 1

ssicefox
Frequent Contributor

Re: Level 3 sprint 1

Hi @JaredDolich @andis,

I am having trouble with the formula in the DAT02 PY Revenue to CY module.

I wrote a formula following to Import Revenue FY19 into DAT02 PY Revenue to CY (dimensioned by A1 Accounts, P2 Products and Time Range)

'DAT01 PY Revenue'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS00 Time Settings'.PY Qtr]

ssicefox_2-1629501430083.png

Then  I received a result following:

 

ssicefox_1-1629500532007.png

 

Seems to be aggregating at the account level for each product.

 

Any guidance would be greatly appreciated!

 

Best regards.

 

Wei

 

 

Misbah
Moderator

Re: Level 3 sprint 1

@ssicefox 

 

Since it is Level 3 we usually don't share the answers & I think this one is simple - Check the dimensionality of Source Module and see how many LOOKUPs are required. I think you are missing one LOOKUP

 

By the way, A2 Account-Product# has to be the dimension of the entire module. Get rid of that subsidiary view.

 

Misbah

ssicefox
Frequent Contributor

Re: Level 3 sprint 1

Hi, @Misbah 

 

Thank you for your hint.

 

I tried 3 lookups (A1 Account, P2 Product and PY Qtr) together, but I received nothing. I think I should import data of P2 Product into the SYS03 before looking up.

 

Best regards. 

Misbah
Moderator

Re: Level 3 sprint 1

@ssicefox 

 

You need to have Accounts, Products line items in SYS module for A2 Account-Products#  populated before you LOOKUP.

 

Misbah

ssicefox
Frequent Contributor

Re: Level 3 sprint 1

@Misbah 

The P2 Product data isn't showed in SYS03.

ssicefox_0-1629535366295.png

 

ssicefox_1-1629535429341.png

I tried to add a formula for P2 Product, but I am not successful.

 

Best regards.

 

Wei

 

Misbah
Moderator

Re: Level 3 sprint 1

@ssicefox 

 

You are very close. You will have to populate "Product Flat" Line item first and then use Product Flat Line item to update P2 Product Line item.

 

Misbah

 

 

ssicefox
Frequent Contributor

Re: Level 3 sprint 1

Hi, @Misbah 

 

Thank you again for your hint. I populated "Product Flat" Line item.

 

 

ssicefox_0-1629541762725.png

 

But P2 Product doesn't have any data as well.

 

ssicefox_1-1629542240304.png

 

Best regards.

 

Wei

 

 

 

 

Misbah
Moderator

Re: Level 3 sprint 1

@ssicefox 

 

As I said earlier you need to reference Product Flat line item, It looks like you are referencing ID line item in your formula within P2 Product

 

FINDITEM(List, Name(Product Flat))

 

Misbah

ssicefox
Frequent Contributor

Re: Level 3 sprint 1

@Misbah 

Thank you for your help.

I got it.

 

Best regards.

 

Wei

SuhasDesai
Occasional Contributor

Re: Level 3 sprint 1

Hello @JaredDolich 

 

When i am trying to enter the formula for Code, getting below error-

 

SuhasDesai_0-1631544830837.png

 

Could you please advise?

 

Thank you. 🙂