Load daily data in a cube structured by a more aggregate time entity
Hello,
How do I load daily data (e.g. date format is 'YYYYMMDD') into a BOARD Infocube which is structured by a higher level time dimension (e.g. month)? Is it possible? Should i apply an ETL?
Thanks and regards
Accepted Answer
-
Hi there,
BOARD comes with an automatic feature that compiles the SQL statement for you when configuring datareaders using ODBC drivers.
If you want to load daily data into an InfoCube structured by month, you can map the day field to the BOARD Month entity. BOARD will automatically aggregate the information at monthly level thanks to the native BOARD time hierarchy.
Note:
The date field that you load from your data source must be in a compatible format for the BOARD Day entity. For example, if you have an Access table with a field called, "Date" and this field is of data type "Date", then this format is not compatible with BOARD. You should use a conversion formula to convert the Microsoft date format into text , such as the following: format$(table.field,'YYYYMMDD')
Hope this helps
Regards,
Michele
1
Answers
-
Thank you very much Michele Roscelli!
I'll try it straight away.
Does it work for any time element which is also existing in the BOARD database time hierarchy? Can i load weekly data into monthly cubes and/or monthly data into a cube structured by year?
Thanks,
0 -
Hi,
yes, this feature works across the time dimension based on the logical relationships - you can check the Time hierarchy tree in a selection window if you are unsure about it!
Michele
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP