Rowcount in universe

[Former Member]

Hi,

I have a transaction log table on which I am builing universe.

This table has no measures, but actually the measure is no of records in the database.

How do I create a measure in universe which gives me the rowcount?

As well as this row count should work at all aggregation levels.

Please help,

Thanks in advance,

CD

[Former Member · Accepted solution]

Hi,

Create an measure with the follwing definition: Sum(1)

Associate it with the table you want to avoid parse error.

Set the aggregation function to Sum.

Regards,

Didier

[Former Member]

Hi,

Try to select any dimension and create measure like

Right click on the class you created and select create object ->

1. object type -> N (numeric)

2. SQL : select count(Dim) from table where conditions (if required)

After creating object go to Object properties (the measure which you created) -> select Count function -> ok

Cheers,

Suresh Aluri.