Hi Folks,
I have a requirement which goes like this.
I have a report whose contents depend on the date of execution. For e.g. if I run the report today, the contents should belong to this month (may). There is a field (call it datefield1) which stores the dates I need. The format of the dates in datefield1 is mm/dd/yyyy. There is only one level in this hierarchy (structure: Dimension-> Hierarchy->level (all)->level(date)->members (members are individual dates with format mm/dd/yyyy).
I have to check for all dates for a month (arbitrary number, based on how many transactions occurred in the month). Is there a way to filter dates related to a month and a year (say 05/2014) in such a setup.
Failed attempts
I was trying to modify the hierarchy in FM by adding month and year levels (is that even possible?). So that the hierarchy look like
Datefield1 Dimension
Hierarchy
Year level
Month level
date level
I was hoping that this would help me in accessing the month/year and the dates within. However the FM does not allow this(is this usual or am I missing something)
In essence I want to create a member set dynamically (i.e. when I execute the report).
Environment
Data connection to SAP BW Bex query
The framework manager model is dimensional
So if I follow you correctly, this is a DMR - a dimensional model within FM? Then yes, I would strongly advise a date dimension to at least have year, month, and day as levels. Create calculated data items for the month and year and use these as the levels. What kind of error are you getting when you try to create the levels?