#MULTIVALUE

[Former Member]

Hi everyone, I'm new in SAP BO Webi.

I'm working with a simple table that show a job status report with Job, Date of Job and State. I want to show last month activity only, so I make 2 variable:

- Max Pariod: Left(Max([Date]);7) = 2015-11

- Period: Left([Date];7) = 2015-11, 2015-10, 2015-09, etc.

Then in the table I compare those variables, por example:

=if [Period] = [Max Period] then [Job Name]

=if [Period] = [Max Period] then [Date]

=if [Period] = [Max Period] then [State]

But when I do this the error #MULTIVALUE appears. I think the logic is right, but I don't know where I'm making something bad.

Thanks

[Former Member · Accepted solution]

Create a measure variable, Period Value as: =FormatDate([Date];"yyyy-MM")

Make sure that you set the qualification to measure as it will default to dimension

Now apply a ranking to your table (via the ranking icon in the analysis menu)

Rank Top 1 on Period Value

Click OK and you're done.

[Former Member · Accepted solution]

I think this is not the answer I'm looking for.

The Job I told runs every weekend, in that case I want to show the current month or the last month (in case we were on the first days of the month and the job haven't run yet).

But I want to show the exact date when the job runs and not the period. I only use the period to get the last data.

[Former Member · Accepted solution]

You can rank on whatever you like. If you want latest date, create a measure variable based on your data object and rank on that instead. The object that you rank on doesn't have to physically be in the block.

[Former Member · Accepted solution]

Work properly!

I had understood something else, but now understand how it works.

Thanks!