Skip to Content

Universe Populate Dimension value based on particular value

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 12 at 12:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 11 at 04:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 14 at 11:34 AM

    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'.

    Add comment
    10|10000 characters needed characters exceeded

  • May 15 at 02:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded