Dinamic Data Reader
Hi community,
I've the following issue to solve.
I have a manual SQL that populates a cube, I need to dinamically pass a parameter in the query
in order to let the user "move between days" on a comparison column.
I would like to let the user populate a field somewhere where he can write the desired number of days (@UserInputDays variable) in order to dinamically populate the comparison cube.
Is there a way to improve this solution? I sow here that for SAP connector something is available.
Kind regards,
Marco
Answers
-
Hi Marco Balduini,
you could achieve that using a ROLAP cube where the user can enter the number of days. You'd have to build a JOIN in your manual SQL statement using both your source table and the ROLAP (or use a sub-select to derive the number of days from the ROLAP and put this in your SQL (instead of the "@UserInputDays")).
Kind Regards,
Helmut
0 -
0
-
Hi Marco Balduini,
you're welcome!
...and, invited to mark an answer as correct if it suited your needs ;-)
Kind Regards,
Helmut
0
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 109 Academy
- 283 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 159 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 310 Partner Hub
- 2 Solution Sales Toolkits
- 92 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP