Skip to Content
0

Universe Populate Dimension value based on particular value

May 11 at 02:24 PM

53

avatar image

Hi All,

I have a requirement to populate the column data,based on a condition.

Example : Data

Expected Output

The Requirement is based on the Material (From) = "F" , populate the From - column .

If someone can help me , if this type of requirement feasible in Universe , WEBI or Crystal Report.

Regards,

Venkat

input-data.jpg (39.8 kB)
output-data.jpg (46.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Venkata Tatatam May 12 at 12:19 AM
0

Hi Jothirmayee,

Thanks for the response. I think you had not got my requirement right.

What the requirement is

From the " Material From / To" - Check for "F" - From and take the relevant data from "Material No" - Column and display for all the relevant row in "From" - Column .

Regards,

Venkat

Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A May 11 at 04:44 PM
0

Hi,

Yes. it is doable.

Create a prompt in Universe to select Material From or you can also have a prompt in webI too.

If you dont want prompt. have a filter on table in WebI or Crystal.

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded
Manish Katyal May 14 at 11:34 AM
0

If you are using Webi 4.2 SP 4 and above, you can easily achieve this by passing a reference to the cell corresponding to 'F'.

Share
10 |10000 characters needed characters left characters exceeded
Venkata Tatatam May 15 at 02:07 AM
0

Hi Manish,

We are in BO 4.1 SP 5 version , we are planning to upgrade to BO 4.2 SP 5. I am not aware of the Reference Cell .

Can you please provide more details.

Regards,
Venkat

Share
10 |10000 characters needed characters left characters exceeded