Hi, I have a Public Dimension that I've been trying to update the IDs and Descriptions for. The import job worked 2 days ago fine. But today whenever I try to important I get the following errors:I've tried creating a new job to import data. And stil...
Hi,I've just reloaded a planning model which has 3 Dates. 2 are Fiscal, one is not. And now on the two Fiscal Dates whenever I create a Restricted Measure or Account if I select either of the Fiscal Dates I only get the option of either Select by Mem...
HiI have requirement where for a table displaying all Doc type other that one (lets call it A) I only show Posting Dates that are after the Last Posting Date for Posting Date for Doc Type A.So if for a particular Order No (the story is restricted to ...
Hi,
I'm trying to link from an Import model to a Live mode using Dimension Linking, using the Cost Centre dimension.
However I am having difficulties with the way the link is being made.
Both Import and Live models are from the same query.
...
Hi,
I'm trying to use Geo enrichment on a Public dimension. It's just a country dimension. I've added Longitude and Latitude as the relevant properties in this Dimension. Then added as part of a model. (Data all fine)
However, when I try to us...
I tried that. And it didn't work. I'm not entire sure how this happened. But it appears that the none fiscal Date had a a Fiscal hierarchy. Despite a non-fiscal hierarchy. Not sure what caused this.
Hi, yes they are. I've created a number of the restricted measures using Date Range on this model in the past. But recently after a data load it appears that I can no longer use date ranges in Restricted measures. I can use them in filters and input ...
I've been trying to use the second help document. But I keep getting a the following:Which isn't helpful as I've followed everything. Any suggestions would be great.
Jef, thanks for this. I've seen option 2 before. Haven't gotten it to work yet.But the first option I was unaware of. Do you have any tutorial on how to set this up?Thanks