I am currently working on WEBI. I am totally new to to it as I started working on it about few weeks ago.
The universe which I am working on does not have the date dimension table. With operational challenges we cannot crete one as it requires certain cost and have few challenges. The transactions are placed in a table with a date. but there is no seperate date dimension table. So now when we have to see month wise trend, What i Do is get the complete transactional data and then create a variable which further divides the data into months etc
The challenge here is that due to the data size the query takes hours. Is there any other solution where we can get month wise data in some quicker way.
I need your help to resolve this issue.As i am totally new to this tool. I will be greateful if anyone can share steps etc. Thanks!