ok, well regardless of the custom question issue. What if i wanted to cut by 2 standard demographics (say age and gender) if they are both in the dimDemographic dimension, I can't have the same dimension on 2-axis in a query.
The reasoning for using SSAS is we have a lot of data that needs to...
Thanks for the reply,
If I'm following you correctly, you would have a dimension for each custom demographic (such as business unit). But every time we upload data, we could have new custom demographic questions, so a new dimension would need to be built for each of those. This seems like it...
UPDATE: I've found this article that seems to be close to what I'm looking for, but it's not quite all there. I'm not really sure how to implement it.
http://www.fcsm.gov/99papers/yost.pdf
Hi All,
I'm struggling with the appropriate way to design my database/cube. I'll start with some background. I'm trying to develop a cube that will allow users to see results of survey data. This survey data consists of what we call demographic questions and metric questions. the demographic...
Hi,
I'm new to SSIS (using 2008). I put together what i thought was the correct way to import data from a tab delimited flat file, do some manipulation to it, and then insert it into SQL Server. Worked great. Then i had a slightly different flat file. It had all the same columns but a few...
Hmm. Yeah, i kind of wish i could record the URL every time i guess there was a site load event in IE.(if that exists) And eventually use it for other browsers. Going to that registry key limits me to IE and it doesn't capture all the sites one goes to, just the sites they typed in. (right?)...
This may be a dumb question but i'm looking for some info that can at least get me pointed in the right direction. I'm a begginner to intermediate programmer and do it mostly as a hobby. I use Vb.net and C#.net. I would like to know how you go about creating an application that can interact with...
Hello. I have a weird problem. I have a listbox that is populated based on the selection made in a combo box. The row source of the listbox(lstCourses) is set to a query i've created. The code i've written is in the combobox's(cboName) AfterUpdate method.
Private Sub cboName_AfterUpdate()...
Hello. I have a weird problem. I have a listbox that is populated based on the selection made in a combo box. The row source of the listbox(lstCourses) is set to a query i've created. The code i've written is in the combobox's(cboName) AfterUpdate method.
Private Sub cboName_AfterUpdate()...
Perfect. I left out that i had a store field too, but i just did another inner join on that field as well, and it came back perfect. Thanks for everyone's help
This unfortunately returns 1 row for each date. I would like to have the results as a row with 3 columns with fields basicly sku, price1, price2. Is this possible?
Hi, and thanks.
i have a table with 3 fields Sku #'s, a date, and a price for that sku. i also have a list of sku's i need to pull and 2 dates that i need to know the price for. Example: what is the price of sku# 10002 on 12/1/04 and 12/1/05. I need this returned all on the same row. I have...
Got it. I used the expressions in the query builder. Had to slightly alter it. used the following incase anyone else needs this. this is for a fiscal year starting on Feb 1.
FYear: Year([fldDate])-IIf([fldDate]<DateSerial(Year([fldDate]),2,1),1,0)
FMonth...
I'm not sure if that helps. Maybe i'm not using it right, but it seems like a way to just add the fields fiscalMonth and FiscalYear to a table. Maybe i'm just not imlementing right. I basically won't to click a report that shows the employees that attended classes in this or any fiscal month or...
I am building a Access 2000 database that tracks classes attended by people in my group. i have a table for attendance with the date they attended as field (mm/dd/yyyy). I need to print reports by Fiscal Month (ie. Fiscal Month 9 includes 10/1/05 - 10/31/05) My database currently is simple with...
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.