Author Topic: OLAP with XLSX?  (Read 6757 times)

Offline lukasz921

  • Full Member
  • ***
  • Join Date: Dec 2018
  • Posts: 13
  • Forum Citizenship: +0/-0
OLAP with XLSX?
« on: 18 Oct 2019 06:35:16 am »
Can I join packet olap cube  with XLSX ?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,086
  • Forum Citizenship: +657/-10
  • Cognos Software Muppet
Re: OLAP with XLSX?
« Reply #1 on: 18 Oct 2019 07:10:45 am »
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.
« Last Edit: 18 Oct 2019 07:13:29 am by MFGF »
Meep!

Offline lukasz921

  • Full Member
  • ***
  • Join Date: Dec 2018
  • Posts: 13
  • Forum Citizenship: +0/-0
Re: OLAP with XLSX?
« Reply #2 on: 21 Oct 2019 12:10:00 am »
ok i know how create dataset. but how create dataset from olap  ? same ? report must be list? crosstab ?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,086
  • Forum Citizenship: +657/-10
  • Cognos Software Muppet
Re: OLAP with XLSX?
« Reply #3 on: 21 Oct 2019 02:46:40 pm »
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.
Meep!

Offline lukasz921

  • Full Member
  • ***
  • Join Date: Dec 2018
  • Posts: 13
  • Forum Citizenship: +0/-0
Re: OLAP with XLSX?
« Reply #4 on: 22 Oct 2019 06:33:30 am »
when I build dataset , after refresh dataset measure in all row is "NULL"

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,086
  • Forum Citizenship: +657/-10
  • Cognos Software Muppet
Re: OLAP with XLSX?
« Reply #5 on: 22 Oct 2019 03:30:34 pm »
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.
Meep!

Offline lukasz921

  • Full Member
  • ***
  • Join Date: Dec 2018
  • Posts: 13
  • Forum Citizenship: +0/-0
Re: OLAP with XLSX?
« Reply #6 on: 14 Nov 2019 12:24:50 pm »
help upgrade to new version or function coalesce in old version