If you are unable to create a new account, please email support@bspsoftware.com

 

Relative Date Analysis for Dashboards- Missing Lookup Reference

Started by MRGK, 25 Jun 2020 03:34:04 AM

Previous topic - Next topic

MRGK

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.

bus_pass_man

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?


MFGF

Quote from: bus_pass_man on 25 Jun 2020 05:07:28 AM
Isn't the category of this question data modules?

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

MF.
Meep!