Search results for query: *

For the second part of your question, I think you should go by the second option i.e. 'A type I dimension table and a SCD table holding just the attributes that can change.' Loading is easy as you only have to updates in the 25 col table. For the other 5 col. table, you can add a row whenever...

I have an employee dimension where I am applying SCD2. This dimension table has 54 fields. The change any of the attributes needs to be tracked , so a record would be inserted.I have already separated out the fields for which I don't need to maintain history (27 fields) into another table. Now...

Thanks for your reply. My whole problem is about representing this in ERWin. As per your suggestion, I should create one entity and do the 4 way join with this entity. Is that correct? Regards

If there are two foreign keys in a fact table pointing to the same dimension table, for eg., two dates like start date and end date to the time dimension table, we can have two different views based on a single underlying physical table. How can this be represented in ERWIN? In ERWIN, when I...

I have four different date attributes which describe an employee's certificate/learning activity.I have created a fact table Learning_Fact with associated dimensions. As per data warehousing design principles, time wil be a dimension.In this particular case we have four such dimensions with...

Thanks. That worked.

Hello, I have created a hierarchy prompt which allows me to drill down on chosen values and also lets me apply the chosen values at each level to the report. This works fine in Desktop. When I run this report in web, it gives me two lists- one for selection, and one where the selected values...

Used Applysimple(to_char(....,'YYYY/MM/DD HH:MM:SS')..)) and extracted the datetime into a text type. Created prompts for this text stuff and used them in a filter with a between operator. This works. My only concern is that with text prompt, what is the validation that we can provide?? At the...

Is there a way to ask for date + time . It should be a value prompt where the user is able to enter the value rather than select from a list of values from database. I have an attribute based on a DATE datatype column in Oracle. I want the user to enter date-time ranges. Passthrough functions do...

Tried the shortcuts. But, getting the same error i.e. 'Filtered element browsing is not supported with a filter that contains prompts'

I have created filters A, A-B (nested with A) and A-B-C (nested with A-B) When I use a nested filter, say A - B - C on the report, The user is prompted for A values first. On selecting, he gets the next filtered list of B values and then the final filtered list of C values. On the basis of the...

Any Way to solve this problem ??? Also..I don't want to display report title in the document especially when I am displaying two reports, one below the other...is there a way??

Features like 'page by' and nested filters are not working in documents. They work fine in web reports thopugh. Is there any way to enable these features in documents?

The problem happened to be not of refresh..actually, the data coming up in the prompts was very different than the data coming up in prompt of the same web report. What is happening is that it is a nested filter and this does'nt seem to be working in documents ! Also, features like page by are...

My reports work fine when run from web. But, on executing a document, I get an old version of the embedded report. Tried options like deleting the document and recreating, restarting IIS, selecting the 'run against warehouse' option on web..but, still this is happening. Any clues as to what...

Is there a away to include an attribute on a report, but, not display it. I want to do this as I need it in the group by of the sql, but, don't want to display it on the report! I need absolute values from fact to be displayed on the report for a,b,c,d versus d I'm doing min(value) for this...

Yes, the sql would look like this. But, i don't want abc to be displayed on the report. I would use this count to arrive at yield and would want to display it week vs parameter (which are other two dimensions linked to the fact table) Also, that ABS function gives problems.

I need a count of records from my fact table based on a condition. I create param_val fact from my fact table F1. One of my dimensions is A1 (based on A1 table having columns Low and High) For each record of the fact table, this param_val needs to be compared to Low and High. I need to count...

I had tried out the custom filter initially by using ApplySimple. But, it had'nt worked. One thing I had'nt tried was that I didn't apply this filter to a hierarchy. I'll try doing that. Thanks !

The ID is distinct. But, DESC has repeating values. Now, if I create an attribute on the DESC itself, I do get a unique list of values to be shown in the prompt , but, the report results get messed up. If I select name1 from the prompt, I do need to show all the occurances of name1 with their...