History not in report

[Former Member]

Dear experts,

All my queries on cube Headcount and Personnel Actions only show data for march 2008.

I have noticed that begda and enda are missng in my cube... could that be the problem? Or are there other things that can cause this?

Please some help.

Greetings

Jessica

[Former Member]

Found it.

thanks any way

[Former Member]

In the data selection tab, there is no condition specified for the month or the year.

Should there be a condition?

[Former Member]

Hi,

do you use the standard BI Content Cube and a standard Query for your szenario?

If yes please post the (technical) name.

Regards

Andreas

[Former Member]

I'am using the standard Infocube, but the query is one i wrote myself.

The query isn't wrong, i'm pretty sure of that. I have written some simple query's to see if it was my query. But even when i have a query with only action type/reason and number of actions and then the calender year restricted on no matter what year, (no 2008 of course) and no data. Unless the year is 2008.

So it must be something else.

[Former Member]

The history is available in the cubes, but i can't get it out into the reports.

I only get the data from march 2008 visible in the reports, the rest is shown as 0.0 or just empty, but the data is available in the cubes.

I do have calmonth but, i don't have begda nor enda.

greetings,

Jessica

[Former Member]

Jessica,

Check out the historic data available or not in the cubes..

Cheer's

HVR.

[Former Member]

Hi

Begda Endda should be there for any HR cube as per standard practice.

In infopackage for this cube.please check if there is any selection condition for month, i think this selection is for March (data selection tab)