topic HyperCube with Master Items (Dimensions, Measures) in Integration, Extension & APIs

HyperCube with Master Items (Dimensions, Measures)

EliGohar — Sat, 16 Nov 2024 05:27:11 GMT

Hi all,

I created a hyperCube using the mashup editor.

When I try to use a measure name from the application, I get no results.

For example:

qMeasures: [{ qDef: { qDef: "# of Objects", qLabel: "# of Objects" } }]

"# of Objects" is a measure in my application which contains the following expression:

count( ObjectID)

If I change the qDef property to be "count( ObjectID)", then I get the expected results.

Is there a way/method to use the master items names from the application and not the fields names?

Thanks,

Eli.

Re: HyperCube with Master Items (Dimensions, Measures)

abhijith28 — Thu, 22 Aug 2019 11:54:08 GMT

Hi Eligohar,

Did you find any solution to use master measures in the hypercube to build the charts.

Thanks,

Re: HyperCube with Master Items (Dimensions, Measures)

EliGohar — Thu, 22 Aug 2019 11:55:48 GMT

@abhijith28 Unfortunately no solution since I've opened this post.

Re: HyperCube with Master Items (Dimensions, Measures)

abhijith28 — Thu, 22 Aug 2019 12:06:04 GMT

Even i am finding the solution. i guess this can be achieved by passing the Master measure id's into the hypercube

Re: HyperCube with Master Items (Dimensions, Measures)

abhijith28 — Fri, 23 Aug 2019 06:34:15 GMT

Hi,

Check the attachment. I guess you can create using this script.

Re: HyperCube with Master Items (Dimensions, Measures)

Øystein_Kolsrud — Fri, 23 Aug 2019 06:34:32 GMT

You mean you want to use a master measure in your hypercube? In that case you should write like this:

qMeasures: [{ qLibraryId: "<object ID>"}]

The page below provides more information, but the important thing here is the note that states "Either qDef or qLibraryId must be set, but not both."

https://help.qlik.com/en-US/sense-developer/June2019/APIs/EngineAPI/definitions-NxMeasure.html