New post
Question
Colin Overton · Jan 19

How can I access cube metadata using the REST API?

#Analytics #Cubes #MDX #REST API #InterSystems IRIS BI (DeepSee)

Hi All,

I'm looking to write a 3rd party front end for BI cubes and have been directed towards the REST API here: https://docs.intersystems.com/iris20222/csp/docbook/DocBook.UI.Page.cls?...

I've had quick test using postman and can use those fine, the issue I have is that there are some areas of metadata not exposed by the api that are essential to write a front end tool. I can list the cubes and measures using the /INFO/ paths, but that seems to be the limit of what is available.

In particular I need to be able to get metadata for Dimensions, Hierarchies, Levels and Member Properties, and a way to list the Namesapces would be good to so that a user can browse those.

Is there any way to get this information?

Thanks

Colin

Product version: IRIS 2022.2
0
0 124
Discussion (6)3
Log in or sign up to continue
Colin Overton · Jan 19

Thanks Evgeny, but that seems to support running MDX which is available through the existing api, it doesn't seem to allow querying the metadata, unless I missed something.

0 0
Sam Duncan · Jan 19

Hi Colin,

It's been a while since I used them, but I think POST /Info/Filters returns some information on dimensions/hierarchies/levels, and POST /Info/FilterMembers returns information on the members of a level. If you need metadata on properties specifically, I'm not sure if that is included. I don't think we have information on namespaces as part of the REST API for IRIS BI, but maybe someone has a suggestion of other ways to get that kind of information about an IRIS instance over REST. Anyway, I'd recommend taking a look at those two /Info services, and possibly opening a WRC issue if you find that they don't provide what you need.

0 0
Colin Overton · Jan 19

Hi Sam,

Looks like there is some information about the levels and members in there so hopefully I can use that to derive the dimensions and hierarchies.

Thank you!

col

0 0
Carmen Logue · Jan 19

Hi Colin -- Looks like Sam got you all the info about what is available now.  Interested in chatting with you about the other things you need -- properties and namespaces and maybe some other things.  Can I set up a call with you?

0 0
Colin Overton · Jan 20

That'd be great, thanks. I'll DM you my email address.

0 0