I am building a VERY large cube that will potentially have 150 million records. Currently I have about 1 million and it is already taking a while to build. We may decide to seperate all this data and use 3 cubes, having 50 million records in each. I am using ONE IQD as the data source. Please...
The now() function uses the database time (and is better to use since it does not invole local processing) while the today() function uses your local time.
Thanks!
Can I rollup from a level other than the lowest level?
For example:
Dimension: Product List
level 1: Product Line
level 2: Product Type
Level 3: Product
I would like to show actuals of level 2 & 3....instead of just level 3.
As a note: I am only using 1 data source.
Thanks!
Here is one to start....
Sometimes when I have a LONG calculation within an Impromptu report I would like to copy & paste it. However, when I try to do this, I get an error and Impromptu closes down on me.
Also, a co-worker of mine wanted to create a report list...but instead of having the...
Hi,
I am trying to create a cube that does the following...
First, I have nested the measures so more than 1 can be seen at once.....
If the user chooses a certain element in a dimension then I would like only 3 of the 9 measures to show up on the cube. Then if the user chooses a different...
Hello,
I am currently creating a cube in transformer and need some help. If the user chooses one dimension I would like it to update the measures with new names, instead of the generic names. For example,
The user can choose a read type (from a dimension) AMPS, VOLTS, or LOAD. If the user...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.