OLAP with XLSX?

[lukasz921]

Can I join packet olap cube  with XLSX ?

[MFGF]

Can I join packet olap cube  with XLSX ?

Hi,

No, unfortunately you can't do this. OLAP cubes are dimensional structures, accessed via MDX queries. Joins are relational concepts, and are enacted using SQL not MDX. You can't join a cube to anything for this reason.

What you can do, though, is to bring the data you need from your cube into a data set, and join your uploaded XLSX to this data set. The data set creation can be scheduled, too.

Cheers!

MF.

Cheers!

MF.

[lukasz921]

ok i know how create dataset. but how create dataset from olap  ? same ? report must be list? crosstab ?

[MFGF]

ok i know how create dataset. but how create dataset from olap  ? same ? report must be list? crosstab ?

Hi,

The UI for creating a data set involves you building a list, yes.

MF.

[lukasz921]

when I build dataset , after refresh dataset measure in all row is "NULL"

[MFGF]

when I build dataset , after refresh dataset measure in all row is "NULL"

Hmmm. That sounds like a defect to me. What version of Cognos Analytics are you using?

MF.

[lukasz921]

help upgrade to new version or function coalesce in old version