asked on June 13, 2022
Hello,
We are connecting to our analysis services through accelerator but we have to specify the Database in the config instead of using the catalogue option in the datasource
"CONNECTION_STRING=Data Source=<server>;DATABASE=<database>" - in config
"type: "microsoft analysis services",
proxyUrl: <url>,
catalogue:<database>,
cube:<model>,
withCredentials:true,
binary: true" - datasource
We were expecting to be able to change the database using the catalogue attribute but without the database specified in the config flexmonster uses the incorrect database (ignoring the one specified in the catalogue attribute), the only other databases we have are the ones created when a user logs into the analysis services (e.g. <database>_cbutton_48689ebf-6b43-4382-a8db-cd145a4bd435).
Are we doing something wrong?
Kind regards,
Craig Button
⋅ June 14, 2022
Hello, Craig!
Thank you for writing to us.
Could you please provide us with the information of what SSAS model you are using?(multidimensional/tabular) Knowing this information will give us additional context and help to understand the described issue.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ June 14, 2022
Hi Maksym,
Its Tabular.
Kind regards,
Craig Button
⋅ June 16, 2022
Hi, Craig!
Thank you for giving us more information.
Indeed, the Database property is not passed into the connection string for tabular modules. Instead, Flexmonster provides the catalog property, which corresponds to the Catalog property of the connection string.
Our team will take a closer look at the Database property usage and return to you with results, ETA 28th Jun.
In the meantime, please let us know in case any questions arise.
Best Regards,
Maksym
⋅ June 28, 2022
Hello, Craig!
We are glad to inform you that it is now possible to set the DATABASE connection string property through the report.dataSource.catalog when connecting to the tabular model via the Accelerator.
This is included in the 2.9.28 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-28/
You are welcome to update the component. Check out our updating tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
A kind reminder is to update Flexmonster Accelerator also: https://www.flexmonster.com/doc/updating-to-the-latest-version/#!accelerator
Please tell us if the feature works.
Best regards,
Maksym
⋅ July 5, 2022
Hello, Craig!
We would like to know whether our feature with DATABASE connection property works for your project.
Looking forward to hearing your feedback.
Best Regards,
Maksym
