Problem with creating measures within Poweplay

[marccain]

Hi!

We are using Powerplay 7.0.705.0 and I'm actualy having a problem with creating a new measure. I added a new datasource which contains forecast volume for our products. The measure itself works fine and the values are joined to the correct product and shown within the report. But after creation of the cube some objects in the time dimension are not shown anymore within Powerplay during creation or modification of a report. As I take a look to the "Show Diagram" Menu option I can still see the Objects (i. e. "Today", "Yesterday") but they are not shown in the report creation tool.

Any Idea? Would be nice to get some help as somebody already had this behaviour.

Regards
Andreas

 

[Draoued]

I suppose your new datasource is marked as "Sets the current Period". As this is the default settings for datasources.

Open the properties of the new datasource , go to the tab "General" , un-mark the "Sets the current period".click OK.

Then you can check that you still have one datasource where is marked as Sets the Current period.

 

[marccain]

Hi!

Great, I'm almost sure that this is the problem. Thank you very much for giving this hint!

Regards
Andreas

 

[marccain]

Sorry, but this is not working. I now put all datasources to not set the current period, except the one where the dates are listet (Invoices). But I still miss the values like Yesterday... Due to that most of our reports are not working with the new model.

 

[Draoued]

do you have an row in your source for yesterday and/or today ??

 

[marccain]

The question that also causes pain is: If I take a look to the Period Dimension than there is the newly created measure shown under "Allocation". But I don't actually know why it appears there or how to get rid of it.

 

[Draoued]

do you have a date field in your new Datasource ???

If you have one , it s exactly with the same name and typo than your Time dimension in the cube ??

 

[marccain]

@Draouded

I do not exactly know what you mean, but there are no dates in the newly created source. There are dates in another source. And there is also no coloumn named "Yesterday" or things like this. One of the coloumns in the newly created datasource was called "Forecast month 01", I already (because I'm almost despairing) removed the coloumn name and set it to "Forecast", but it did not help.

 

[Draoued]

if you want your measures to follow the Date dimension , you need to have a date field in your source. Otherwise transformer is allocating the measure in the date dimension. Meaning what ever level you are in the date dimension , your measure is a constant figure.

If you are bringing your forecast figures for 1 month only , then you can add a fake field containing a "date", like 2005-01-01 , so it will go under Jan 2005

 

[drlex]

marccain,
I had a similar problem with special date categories being absent from the model. I solved it by moving the data source that set the current period to the end of the data source list.
lex

soi la, soi carré

 

[marccain]

Thanks for you answers. I already tried to move the source up and down, with no result. I managed to follow what Draoued said. That's leads to not loose the entries in the Period dimension, but after that every value seems to be zero in the forecast source. But I did not have to much time today to test. I will continue on friday. Hopefully it gets solved then.

Andreas