Member since ‎04-26-2009

User Statistics

  • 328 Posts
  • 1 Solutions
  • 3 Kudos given
  • 0 Kudos received

User Activity

Hi All, Choosing the schema for Universe is based on underlying datawarehouse schema design ? especially if it has to be snowflake Universe ? since In Snowflake Schema each level of a hierarchy is stored in a separate table by normalizing the dim...
I am able to sum measures from different tables in Webi variables but unable to do the same in IDT measure object. How do i sum 2 measure objects from 2 different tables in IDT . Thanks .
Hi All, I used = RunningTotal() in variable but I will need it in Universe too , How do i get this one in IDT unv. Thanks a lot.
I have to concatenate 2 dimension objects as below comp code : desc 10200: abc Banking comp Both 'comp code' and 'desc' are strings , yet I get ORA-01722: invalid number error. How do i concatenate these 2 dimensions in IDT. Thanks everyon...
Why is my variable getting an extra blank row , I do not want it , its getting Null_value which is not there in LOV but only appear when i write the variable =[Query 1].[Year] Where ([Query 1].[Offset year] = (-1)) I have this extra blank row wi...
Kudos given to