Best Of

Hi Egon Santoni, one option to perform the logic inside BOARD is to load both tables as they are and perform the processing via dataflow action of a procedure.

For this you need 4 cubes:

A Begin Date (Date type cube dim by Person) - populate from SQL

B End Date (Date type cube dim by Person) - populate from SQL

C Day (Date type cube dim by day only) - populate via dataflow using Day = day() function to hold date values for every day

D Active Flag (Integer cube by Day by Person)

To populate D, you need IF statement =if(and(c=>a,c=<b),1,0)

You can then multiply any anagraphic data by this ACTIVE flag mapping to have only values shown in days the Person was active, or even use the Active Flag as a filter in the layout depending on what you are trying to do.

I hope it helps!

Thanks,

Audrey

Hi Alberto,

It's certainly possible. The approach is to create an Integer type cube that you enable for data entry in a settings screen.

You would then process the data via dataflow, (c=a*b), ex:

A* Actuals (Month, GL Account, Department, Company, etc)

B Mapping cube (GL Account, P&L Report Line)

= C Report Cube (Month, GL Account, Department, Company, P&L Report line)

You might need some intermediary cubes to stage the data, but the above is the general idea. 

Hope that helps! Let me know if any questions.

Dear BOARDville Citizen, 

There are different methods to add a new element in BOARD. We often refer to these elements as "members" of an entity. You will need the help of a BOARD administrator to complete the task.

1. Create a data reader protocol to populate the entity with new products - either from a flat file or from a database connection (more here: Data Reader basic concepts)

2. Manually add the member from the entities tab (more here: Inserting, editing and deleting entity members)

3. Often for planning/forecasting purposes you may want to provide the ability for the end user to add "one-off" products - you could use a functionality Advanced Transformation Object to provide the user the ability to do this from a pager on the screen (more here: About ATO ). A poweruser in BOARD could complete this step for you.

Hope that helps!

Cheers,

Audrey