Not seeing SETS from OLAP cube in Dundas BI

#1

HI,

We are running into issues where we need to see SETS from our OLAP cube (our main data connector) within Dundas. We only see measures, dimensions, and hierarchies but NOT seeing SETS. Last time we spoke with Dundas support (couple months ago) they mention we should see this and if we do not it may be a glitch. Just wondering if anyone else has experienced this and if anyone has more info about it.

Thank you in advance.

-Semir

#2

Hi Semir,

We don’t yet support selecting named sets from OLAP cubes directly onto metric sets, so I’ve added you as a submitter to the feature request. Maybe we mixed these up with Dundas BI’s named set tokens in filters when talking to you previously?

For now you should at least be able to access them by using MDX in a data cube first.

#3

HI Jamie,

Thank you for your reply. Unfortunately, we use OLAP cube as a single source of reporting across our organization and have been trying actively to replace SSRS/Excel with Dundas BI as much as we could. We have over 400 custom calcs in OLAP as well as many NAMED SETS (especially for our financial data, i.e. account groupings, etc.) so we really need this ‘future’ feature :)…To further clarify, when you said ‘data cube’ in your reply, you meant writing MDX query that is referencing needed Named Sets (i.e. say coping it from existing MDX query in SSRS report into Dundas BI (data cube area))? If so, would you have any other suggestions? One thing I was wondering and would hope you can confirm it would work is creating a ‘data cube’ in Dundas BI but build needed sets (account groupings) in SQL data source (our DW) and combine it then with the OLAP cube in ETL area in Dundas BI - would something like this be possible?

Again, thank you so much for your help and hoping this feature request is added soon.

Thank you,

-Semir

#4

Hi - Yes I was referring to a data cube created in Dundas BI with the Manual Query option and an OLAP cube selected as the source. I can’t help you much with the MDX itself, but copying an existing query is a good idea. Once you’ve selected data from an OLAP cube into a Dundas BI data cube, you can join that result with any other data source you need (as long as the unique names or other values you selected match the other source.)