How can I access cube metadata using the REST API?

Question

Question

Colin Overton · Jan 19, 2023

#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

Discussion (6)3

Log in or sign up to continue

Sam Duncan · Jan 19, 2023

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

score 0 · Answer 1 · 2023-01-19T09:39:48-05:00

Hi @Colin Overton !

Try MDX2JSON, it should have what you need.

Also try DeepSeeWeb, maybe it does what you are looking for.

score 0 · Answer 2 · 2023-01-19T11:27:52-05:00

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.

score 0 · Answer 3 · 2023-01-19T12:31:18-05:00

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

score 0 · Answer 4 · 2023-01-19T13:22:30-05:00

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?

score 0 · Answer 5 · 2023-01-20T05:35:18-05:00

Colin Overton · Jan 20, 2023

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

0 0