About ciara

ciara · ‎08-08-2020

Thank you so much, While its not ideal to hardcode FY19, its better then not having the correct %. Thanks 🙂

ciara · ‎08-07-2020

Hi, I am currently working on creating a P/L where we multiply a item by a certain percentage. To get this percentage, I had to create a another module and use past actual data to arrive at the %. The issue is now In my module of calculating the % . FY19 is the percentage I need to bring over to my P/L but everything I have tried doesnt seem to be able to bring in only FY19 %

ciara · ‎07-15-2020

Thanks for getting back to me. 1- The Line items are line items (The normal P/L items) 2- I put the rows as a subset (Ext RI, Net, Gross etc) 3- Other dimesions are time, and entities. ( I hope to link the gross to another module then use the other columns to build formulas off the Gross figures.) 4. So the Gross is the total (which I am taking from another module) then the other ones I am using ratios to multiply the gross to break it down and others just to subtract. My issue when doing this is the formula will link all items in gross to revenue rather then to the matching name. Hopefully I am making myself clear. Apologies if I am not.

ciara · ‎07-15-2020

@anirudh Hi, Thanks, I have tried that and the forumlas wont breakdown. For the Revenue line, I need a different formula in each column and when I try insert subsets the formula drags down to each line item in the column

ciara · ‎07-15-2020

I am trying to create formulas for a P/L account. I need Line items but I need the formulas across the columns to be different. I cant find any details to this on your website. How is this possible? Gross will link to another module I/C will be Gross multiplied by % with another module Net I am taking the 1st two away from one another

ciara · ‎06-22-2020

@Kanishq17 @einas.ibrahim @abhi1017 .thanks so much, the last part was a simple typo.

ciara · ‎06-22-2020

Im nearly at the stage to give up. Been stuck at this area for 3 days 😞

ciara · ‎06-22-2020

Thanks, DAT03 uploaded with error. It was mapping. One had Volume and another had volumes. Sorry. I have ran the action and it seems to have ran with errors and again the volumes is the issue. I am missing that is very stupid I know just I cant find this in the trouble shooting area

ciara · ‎06-22-2020

Hi, thanks for getting back, that doesnt seem to work wither

ciara · ‎06-22-2020

Sorry I meant the Action wont run. I just tried it to see. The import from Data hub to supply chain gives the following.

ciara · ‎06-21-2020

Hi, Yes, Im using the that time line When I upload the DAT03 I get the error in my 1st post and when I run the import in the Action I get the error DAT03 can not be found

ciara · ‎06-21-2020

Hi, Thanks 🙂 I havent changed the name of the Data Hub from Sprint 1

ciara · ‎06-21-2020

Hi, Im currently on Level 2 Sprint 2. For Importing the DAT03 from the Data base to the Supply Chain, I keep getting a error This is stopping me from running the proccess 9. I have connected the Supply chain to the Data hub. Please help, I am lost and have gone back to see what I have missed but nothing is coming up

ciara · ‎06-10-2020

Oh thank you.... simplest thing!! thanks

ciara · ‎06-10-2020

It is the same for all costs

ciara · ‎06-10-2020

I am loading this into EMP003 and the txt file to SYS08 imported to As

ciara · ‎06-09-2020

Of the excel/text like the imports?

ciara · ‎06-09-2020

The imports is it?

ciara · ‎06-09-2020

@Kanishq17 Its the cert Q4 to get the medical Costs. I have tried this for 2 days different ways so I must be missing something

ciara · ‎06-09-2020

Hi, I have trying to complete the Medical costs for 2 days now and I can figure it out. I created the list of roles: Created EMP003 Employees-imported employees by roles data Added Roles to SYS08 then imported the txt: I try to amend the formula to take in EMP003 annd SYS08 Roles Medical costs - IF Employed? THEN 'EMP003 Employee Drivers By Role'.Medical[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 It keeps failing saying format of mapping used for lookup doesnt match any dimension of the source

ciara · ‎06-09-2020

Hi I have done what you said and checked Sindy which was correct, but the figure I get for Medical for Finance in Dec is wrong. 36800. I am doing something wrong I just dont know what

ciara · ‎06-08-2020

I am just doing the test now, question is asking about FY21. All my downloads are actual 2019 and budget 2020. Am I missing something

ciara · ‎06-08-2020

Hi, I am trying to filter on Forcast periods and I cant seem to get it to work.

ciara · ‎06-07-2020

I am having issues when I import, this is what I have done. Only one size gets imported

About ciara

Re: Adjusting a formula

Adjusting a formula

Re: Question on Formula for headers and line items

Re: Question on Formula for headers and line items

Question on Formula for headers and line items

Re: Import into DAT03 Historic Volumes

Re: Import into DAT03 Historic Volumes

Re: Import into DAT03 Historic Volumes

Re: Import into DAT03 Historic Volumes

Re: Import into DAT03 Historic Volumes

Re: Import into DAT03 Historic Volumes

Re: Import into DAT03 Historic Volumes

Import into DAT03 Historic Volumes

Re: Medical Costs-Cert Question

Re: Medical Costs-Cert Question

Re: Medical Costs-Cert Question

Re: Medical Costs-Cert Question

Re: Medical Costs-Cert Question

Re: Medical Costs-Cert Question

Medical Costs-Cert Question

iRe: Level 1 Model : Dimension of mapping used for...

Level 1 Cert Exam

Saved View Name: EMP02: Forecast Periods

Import Data into SYS06 Product Details

Re: Import Data into SYS06 Product Details