I am not able to display value using Data picker, here are the steps i have done from start,
let me know if i am missing on some part to help rectify this.
Step 1: Created a new Entity (SalesReport)
Step 2: Created a cube name SalesCube (Using SalesReport in structure)
Step 3: Created Rule and used Data picker Syntax to fetch the summarized Sales Value from Actual Sales Cube with physical name V003
Here is the image of all cube with physical name:
and below is what i had mentioned in Rule
Step 4: Created Dataview with Layout as Follows:
DataSelection: SalesCube, Functions: SalesRpt (<-The same rule which is created above)
Step 5: Value mentioned in Data Picker is not being Displayed
Can you please guide me in where i am making mistake, so that i can rectify it and get the desired output.