Best Of
Re: Difference Time
Dear Wahyu Nugraha,
thanks for your request.
For general, when you calculate the differences between Cubes, the calculation is based to the Dimensions the cube is belonging to.
For your Case a DataFlow "FC-Admin" - "Choose Year" will bring the result -1 for 2017 and 1 for 2018 because each year is calculated separately.
Perhaps our E- Learning portal helps you to understand how BOARD is working.
regards
Alexander Kappes
Re: Change / tranport of changes through landscapes (Dev, QA, PRD)
Dear Johan Kotze,
in genreal it´s no difference if you use the Transporter for Cloud or onPremise instances.
regards
Alexander Kappes
Re: Installing Board client in Citrix
Dear Ahmed Lattali,
thanks for your request.
You can just use the setup.exe to install the BOARD Client on Citrix Application farm.
It´s recommended to install the Standard Edition of the client, because using the AutoUpdate Version means that for each User the client is installed a second time in his appdata folder.
Hope it helps
regards
Alexander Kappes
Re: Using date rolap cube with selector on Time Entity
Dear Mariusz Toporowski,
thanks for your request.
Selectors just working for BOARD entities, not for Cubes.
In your case, when you insert a selector for ETB, and select something from that, you will see, that only the choosen slice of your Cube will be shown.
Hope it helps.
regards
Alexander Kappes
Re: Create report function in Board Web environment
Dear Stephen Mattson,
please check if "Microsoft Visual C++ 2013 Redistributable" is installed on the machine where the WEB API Engine is hosted, if not please install it and spend another try.
Let me know.
regards
Alexander Kappes
Re: Reverse algorithm cannot works with Date/Text Cube
Dear Miriam Alierta,
you are right in 9.1.0 reverse algorithm for Text and Date Cubes make Problems.
Good News on this, in the actual 10.3 release it is working fine. Means the issue is fixed in the meantime.
regards
Alexander Kappes
Re: excel source file
Dear Niharika Kakarla,
doing this you have 2 opportunitites
1. You generate (export) CSV Files out of your Excel Files
2. You use EXCEL ODBC Connection
Hope it helps
Regards
Alexander Kappes
Re: excel source file
Dear PIETRO DI CINO,
it´s exactly the same as using ODBC for MS SQL or each other database system.
For excel you have to do the following special configurations
1. you have to define "Names" for your EXCEL Sheets, this will be later the table names in the odbc
2. the excel has to be placed on the server. (By the way it isn´t working when the file is opened by anybody in EXCEL Client during the load with board)
3. you have to install the odbc driver on the machine where the board engine is running. The ODBC itself can be downloaded from MS for free: Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center )
Hope it helps
regards
Alexander Kappes
Re: How to delete a replicated axis ?
Dear Etienne CAUSSE,
we had the same curiosity at other customers.
There it was solved by the following way.
1. Delete the Replicated entity
2. Change or insert some other entity
3. Save and Reload the DB
for that customer we got it work in that direction.
perhaps it helps
regards
Alexander Kappes
Re: Select @user onLoad for a pager?
Dear Bob Gill,
I think the only way for you will be inserting custom selection script into your database Security profiles which looks like:
Select Entity = @User
Only thing you have to check is that the Usernames in the entity are the same like the login Accounts.
Hope it helps.
regards
Alexander Kappes