Total posts:
Notice (8): Undefined index: newest [ROOT/plugins/Forum/src/Template/Home/index.ctp, line 39]

Newest

Total posts:
Notice (8): Undefined index: frequent [ROOT/plugins/Forum/src/Template/Home/index.ctp, line 164]

Frequent

Total posts: 50

Votes

Marcus



What is the use of working tables in our ETL?

Why do we need working tables in our ETL? Wouldn't it be easier if we have all our attributes in one table. ...

448
Views
7
Votes
7
Answers
JasmineJiang



Why OLAP cannot bulid sucessfully?

Does anyone know that why OLAP cannot build successfully when full name exceed the number characters? ...

541
Views
7
Votes
14
Answers
Marcus



Is this a good example for a graph?

It is the credit limit for all the credit card users in the database. Thanks. ...

1897
Views
6
Votes
19
Answers
Marcus



How do I use values from the dimension table as measures?

Is it possible to use values from the dimension table as cube measures? So far I've only been able to use them as Distinct count instead of the values in the table. Thanks! ...

559
Views
6
Votes
13
Answers
XavierLZH



I need some help with OLAP cube!

While editing the definition of a cube within the Cube Designer of SAS OLAP Cube Studio, I encountered this error. ERROR: Incomplete cube metadata detected. ERROR: No input table. ...

559
Views
5
Votes
10
Answers
XavierLZH



I tried to open a project from program history, instead it opened a blank project or display an exception

Exception information Path 'C:\Users\userid\AppData\Local\Temp\2\SEG42212\KnvA73dVT2OWIX8v' doesn't point at a valid Git repository or workdir. ----------------------- ...

2344
Views
5
Votes
4
Answers
XavierLZH



What is SAS BI Dashboard Portlet?

I am currently doing the SAS project, just finished my OLAP cube but I am confused because I don't know what is this used for, and how it can help to display graphs. ...

1248
Views
5
Votes
13
Answers
JasmineJiang



SAS Management Console

Why do we have to update metadata at SAS Management Console in order to see the changes in SAS Enterprise Guide? ...

558
Views
5
Votes
10
Answers
JayceEr



Measures for Auto Loan

Hi all, what measures should be used for auto loan and auto loan payment in OLAP. Examples would be much appreciated :) Thankyou :) ...

508
Views
5
Votes
14
Answers
Pearline



WHY FACT TABLE cannot consist range value

Mr jason said that we cannot put range values in fact table. I didn't had time to ask him why. can someone please explain to me. Thanks ...

518
Views
5
Votes
8
Answers
yeeqinghew



OLAP CUBE NWAY aggregation

Hi, anyone knows what is a NWAY aggregation ? What is the use of it and when do we use it ?? Thanks :)) ...

736
Views
4
Votes
7
Answers
Pearline



How to create time dimension?

Hi, so basically i want to create a time dimension from a date time format. However i do not know how to :( ...

640
Views
4
Votes
20
Answers
yeeqinghew



After building OLAP CUBE

What are we gonna do after our OLAP CUBE ?? Is it move on to Information Maps or straight to Dashboard ?? ...

446
Views
4
Votes
10
Answers
Scottt



How do i solve this?

i received the message "Not enough quota is available to process this command" Application Error SAS Enterprise Guide needs to close SAS Enterprise Guide has encountered a problem and needs to ...

1964
Views
4
Votes
7
Answers
Marcus



How do I solve this error in olap cube?

I can't seem to solve this error on olap cube is it because of the format, if so how do i change it? https://postimg.org/image/6oq3eixm5/ ...

1540
Views
4
Votes
11
Answers
FarhanaMahadi



Unable to open input data.

Has anyone ever encounter this problem? It was working fine initially a few days ago until today when I clicked onto the table, this problem occurred. ...

468
Views
4
Votes
10
Answers
JiangPing



How to i perform substr starting from the back?

help me why it isnt posting my ask question .....I think this system actually don't want to be go celebrate Chinese new year with my fam ...... oh well back to work ermmm I was ...

437
Views
4
Votes
5
Answers
Alysha



SAS BI Dashboard (query return)

QUERY ERROR! Query error for indicator data 'test' This query returns > 10000 rows. The maximum number of rows permitted is 10,000. To reduce the number of rows returned by ...

1414
Views
3
Votes
5
Answers
JiaQii



Attribute Byte Length

Why attribute byte length will return back to normal after updating it? Example, changing from 8 bytes to 256 bytes. But when i close SAS EG and reopen it the byte length will return to 8 bytes i ...

480
Views
3
Votes
6
Answers
155952D



Data Indicators. What are they used for?

Are the dashboards made up of different indicators? If so are dashboards based on the indicators or the information maps? Since the indicators can also be made from information maps whats the diffe ...

493
Views
3
Votes
10
Answers
Farhana



More than 1 OLAP cube per fact table ? YES or NO

hi, is it possible to have more than 1 OLAP cube per fact table? If no, wont it be too complicated and messy if 1 only have 1 OLAP cube per fact table ? Can you suggest ways too make it less compl ...

597
Views
3
Votes
12
Answers
JiangPing



How to add an additional column in my table???

in need of help pls help me i want go back celebrate cny with my fam thanks in advance was given a mission impossible to do >.>............................................. XD ...

467
Views
3
Votes
14
Answers
Scottt



sas enterprise displays "ERROR: Unable to get SAS code. Value cannot be null."

Parameter name: ServerName and LibraryName cannot be null or empty; ERROR: Unable to get SAS code. Value cannot be null. Parameter name: ServerName and LibraryName cannot be null or empty??? ...

701
Views
3
Votes
6
Answers
yeeqinghew



Hierarchy in OLAP CUBE

Hi, anyone knows what hierarchy should I include in my credit card sign up fact table in OLAP CUBE? For example, Time Dimension: Year > Quarter > Month Customer ...

427
Views
3
Votes
10
Answers
gracesng



how do you design dashboard ? do we need to integrate into SAS portal?

how do we design dashboard? are we suppose to integrate everything ? is there a need for web report? ...

698
Views
3
Votes
9
Answers
ChinHin



What is a range in SAS dashboard?

Must we have a range? Is the range used for indicator data or indicator? Do i create the range first or the indicator first ...

394
Views
3
Votes
10
Answers
155952D



sas enterprise might display errors about removing project items

when i open my project , i see a pop-up message box with one or more notes that are similar to the following: An unknown error occurred while trying to create the project item with label "somethin ...

634
Views
3
Votes
8
Answers
ChinHin



Problem creating a computed column

Hey guys i want create a measure by using computed column which involves taking a value dividing another value any idea how do i write it out using advance expression? T.T ...

452
Views
3
Votes
9
Answers
JunJie



Cannot update ETL table

I cannot update my dimension table in enterprise guide as they keep prompt the error of I not the valid administrators. With this, I cannot change my things. ...

486
Views
2
Votes
2
Answers
AlvinTan



Can i create more than one cube using only one fact table ?

I created a cube using only part of the attributes in my fact table. I would like to use the remaining attributes to create a cube as well. Can i create another cube or i would have to divide my f ...

605
Views
2
Votes
12
Answers
Kailiang96



LOCK UP WHEN CREATING OLAP CUBE

Anyone faced the same problem or have any ideas why would get lock up when creating OLAP CUBE? Thanks in advance. ...

560
Views
2
Votes
11
Answers
Farhana



What is the difference between predictive analysis and forecasting ?

I would like to know the difference between predictive analysis/ prediction and forecasting. Give cases when predictive analysis and forecasting is used. ...

581
Views
2
Votes
11
Answers
Alysha



SAS Information Map Studio

in the Selected Resources, are you suppose to get the attributes from fact table or dimension table? ...

416
Views
2
Votes
10
Answers
gracesng



What is a SAS BI Dashboard?

What does a dashboard use for? does it only show graphs or report? whats the difference between a SAS BI dashboard portlet? ...

618
Views
2
Votes
7
Answers
Scottt



How do i solve this?

I received the following error message when i opened SAS enterprise Exception Details: Exception type: System.Xml.XmlException Message: ...

1744
Views
2
Votes
4
Answers
SandyTang



Purpose of SAS BI Dashboard

In Dashboard, when are we require to use new indicator, new indicator data and new range. What is the different between them? ...

2547
Views
2
Votes
12
Answers
Alysha



Visualization Outcome

What is the difference between dashboard, Web Report Studio and Portal? and which is better to use to present as a final visualization? ...

635
Views
2
Votes
8
Answers
Lili96



SAS Web Report Error

This error occurs when I view my data in Web Report Studio Help. The data value is one ...

510
Views
1
Votes
2
Answers
OngChenYu



What is the BIA implementation process? Anyone can explain the BIA Implementation process ?

What is the BIA implementation process? Anyone can explain the BIA Implementation process ? Thank you !!! ...

628
Views
1
Votes
2
Answers
Suhaila



Hierarchy In OLAP Cube

What is the difference in these three hierarchy; default hierarchy, multiple hierarchy, ragged and unbalanced hierarchy for a dimension in OLAP cube? When to know which hierarchy to be used? ...

962
Views
1
Votes
6
Answers
Ken20008



Best Way To Learn Web Design

What is the best way to learn web design? Online courses? I found some nice in-person courses for HTML/CSS coding, think those are good. Could anyone advise? ...

129
Views
1
Votes
0
Answers
darrenlee98



How to deal with empty values?

I have some values that are empty and I want to change them. Do I need to change them from access or something else? ...

771
Views
1
Votes
16
Answers
Suhaila



Common Operations In OLAP Cube

Can someone explain the data tables and common operations in OLAP cube, what are they used for and when to be used? ...

1613
Views
1
Votes
5
Answers
Suhaila



What’s the difference between SAS Enterprise Guide and SAS DI Studio?

What is the difference between SAS Enterprise Guide and SAS DI Studio? What are the advantages among them? ...

1475
Views
0
Votes
7
Answers
Farhana



What is a SAS Library and how is it different from metadata?

I would like to know the difference between the SAS Library and metadata. I was told that these days, many SAS processes rely increasingly on metadata. Why is this so? ...

1153
Views
0
Votes
7
Answers
Suhaila



Data Warehouse VS OLAP cube

What is the difference between data warehouse and OLAP cube? Are they deprecated in comparison with each other? Are there any performance issues in one of them? ...

935
Views
0
Votes
8
Answers
156050E



What is multidimensional expressions(MDX) ?

The multidimensional expressions (MDX) language is a standardized, high-level language. What is the use and characteristics? ...

582
Views
0
Votes
6
Answers
OngChenYu



What is the level of intelligence through Analaytics?

What is the level of intelligence through Analaytics? I think we have learnt before in lecture, just curious . Anyone knows ? ...

719
Views
0
Votes
3
Answers
IrfahIsham



Cannot view data of fact table in SAS OLAP Cube

The table data cannot be retrieved when want to "View Data" of the fact table that consists of a computed column. It says data cannot be retrieved because it has the symbols(+=-<>||). Can kno ...

714
Views
0
Votes
6
Answers
ruonan



What is cross selling ?

What is cross selling ? Anyone heard of it ?I seen this somewhere before while looking at some analysis guide . ...

3306
Views
0
Votes
5
Answers

Unanswered

Total questions:

My Questions

Total answers:

My Answers