Best Of
Re: Difference between algorithm and Dataflow
Hi Antonio,
I understand better now. Does this change if i apply a different TOTAL option in the layout block?
Is this a feature that might resolve the behavior?
Thanks
Re: All masks disappeared!!
i have found the duplicated Mask and removed it.
It is all working correctly now.Will remember this next time
Cheers,
Re: Cannot Run Requested Analysis: error
Thanks Michele
i have changed the Row Upper limit and now the report is displaying correctly.
That was very helpful
Re: Unable to apply analytical function
Hi Antonio,
i have tried adding another dimension with 1 element and loaded the infocube against this new element.
It works perfectly, thanks!
Re: Where can I get good icons, backgrounds or palettes?
To add to tools for color palettes I really like to use Adobe Color CC (free). Favorite feature is the ability to upload any image and generate a series of color palettes.
Re: Best steps to create a company master template
Hi Annika,
I really like Bjorn's idea of the template capsule/styleguide.
One thing to add if you are using the web client, do not forget that you can customize the logo and landing page background.
Reference: Theme section of this article
Re: Cannot start Board 10 Server. Original cause: This license does not allow Board to run in 64-bit mod
Hi Christopher,
The server would give you this error if your license key has expired/is not valid. I hope that helps!
Re: How to know which Datareader populates and Infocube
As the others suggest, metadata extract can help you out here.
Not immediately helpful, but keep an eye out for the improvements in BOARD 11 related to metadata mangaement. This type of information will soon be searchable within the BOARD application itself.
Re: Get active person by selecting a date
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
Re: Mapping in Board
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.