Author Topic: Relative Date Analysis for Dashboards- Missing Lookup Reference  (Read 484 times)

Offline MRGK

  • Associate
  • **
  • Join Date: Jun 2020
  • Posts: 1
  • Forum Citizenship: +0/-0
Hi,
I am trying to use Fiscal Calendar Data module with the Published package of my business Data. I followed the steps of the video which shows how to use Fiscal Calendar.
https://www.youtube.com/watch?time_continue=2&v=4lDrF3jx98g&feature=emb_logo

To connect the Fiscal caledar to my data source, I need to add Fiscal Calendar in the date column of my source in the Lookup reference. But all i see is , everything is inactive and I cannot change anything and I dont see Lookup Reference .

Could anyone please Help me with this issue.

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 435
  • Forum Citizenship: +43/-0
Re: Relative Date Analysis for Dashboards- Missing Lookup Reference
« Reply #1 on: 25 Jun 2020 05:07:28 am »
Unfortunately you would need to provide slightly more information.

Define "inactive".

What actual steps have you performed?

The query item in your fact table which you use to set its lookup reference to the calendar needs to be a date data type.  If the fact table has such a column then it can be used.  If it doesn't, you need to create a calculation which produces dates which represent the appropriate dates in the fact table.

You then set the lookup reference for each of the facts which you wish to have relative time measures.

Isn't the category of this question data modules?

« Last Edit: 25 Jun 2020 05:26:03 am by bus_pass_man »

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,086
  • Forum Citizenship: +657/-10
  • Cognos Software Muppet
Re: Relative Date Analysis for Dashboards- Missing Lookup Reference
« Reply #2 on: 25 Jun 2020 07:03:24 am »
Isn't the category of this question data modules?

I have moved the post to the Data Modules board... :)

MF.
Meep!